SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, p.product_id, p.main_image, p.main_list_comment, p.comment2, p.update_date, p.sub_title6, MAX(price02), MAX(price03), MAX(stock), pc.point_rate, p.sales_datetime, p.sales_end_datetime, IF(p.tweet=p.tweet, 1, 0) AS tweet, p.name, p.movie_s, GROUP_CONCAT(cc.name separator ' ') AS classlist, GROUP_CONCAT(pc.stock separator ' ') AS stocklist
FROM (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
LEFT JOIN dtb_products_class AS pc ON p.product_id = pc.product_id
LEFT JOIN dtb_classcategory AS cc ON pc.classcategory_id1 = cc.classcategory_id
WHERE p.product_id IS NOT NULL
AND p.del_flg !=1
AND p.status =1
AND (p.sales_end_datetime IS NULL OR p.sales_end_datetime >= '2024-04-29 03:45:29')
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 120
37375 Hi-STANDARD×MISHKA EXWDHS02H SPHINX PULLOVER WHT
42599 Bentham ロゴプルオーバーパーカー
11160 MEMPHIS MAY FIRE Shield Heather Hooded
45657 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: AMO SYMBOLS
23591 HER NAME IN BLOOD HOODIE
57100 Survive Said The Prophet SIDE ZIP HOODIE
23834 SAME LOGO HOODIE BLACK
23835 SAME LOGO HOODIE NAVY
23836 T/ssue LOGO HOODIE GRAY
23837 T/ssue LOGO HOODIE BLACK
26318 STRUNG OUT STWB Pullover
45121 acOlaSia × ぽにきんぐだむ コラボパーカー
39270 HER NAME IN BLOOD FIRE LOGO PULLOVER
22853 四星球 2015パーカー(B)
22854 四星球 2015パーカー(A)
23453 HER NAME IN BLOOD NEON HOODIE
18040 四星球 MMM4パーカー
23819 ENTH LOGO HOODIE BLACK
23821 ENTH LOGO HOODIE GRAY
43342 BRING ME THE HORIZON DYNAMITE HOODIE
28415 SpecialThanks missaパーカー プル
32813 Bentham サークルロゴパーカー グレー
44851 ROB ZOMBIE×KILL STAR CLOTHING Hellbilly Hockey Jersey
45700 RUDIE'S "Nothing's Carved In StonexRUDIE'S COLLEGE HOOD SWEAT" GRAY
24410 【ゲキクロコラボ】Equal × ゲキクロ プルオーバー・パーカー
41759 Survive Said The Prophet WABI SABI HOODIE (NATURAL)
41760 Survive Said The Prophet WABI SABI HOODIE (BLACK)
43315 Survive Said The Prophet BBL HOODIE (NAVY)
43316 Survive Said The Prophet CALLIGRAPHY LOGO HOODIE
22765 ヒステリックパニック 悪眼(あくめ)パーカー
29040 PassCode Hoodie『TRIAL』
30137 BAND-MAID deathsight パーカー 黒
30138 BAND-MAID deathsight パーカー グレー
32251 【ゲキクロ限定】 BAND-MAID deathsight パーカー PURPLE
22608 アーバンギャルド ガスマスクパーカー WHT
22786 ANGRY FROG REBIRTH メタルロゴ プルパーカー
53937 そこに鳴る ビッグシルエットパーカー
53941 Bentham big silhouette hoodie
56144 Unlucky Morpheus CHANGE OF GENERATION パーカー
28370 ALL OFF×LILWHITE. UNITE Hoodie
42630 KEYTALK 刺繍パーカー グレー
42632 KEYTALK 刺繍パーカー ブラック
44211 【限定アイテム】Maison book girl Zip Hoodie Black
46181 Survive Said The Prophet UNDER BAR HOODIE
46182 Survive Said The Prophet RIGHT and LEFT HOODIE
49721 Survive Said The Prophet NEW SCHOOL HOODIE (BLACK)
49722 Survive Said The Prophet NEW SCHOOL HOODIE (NEON YELLOW)
57099 Survive Said The Prophet MONO TONE HOODIE
65845 各務華梨×GEKIROCK CLOTHINGスペシャル・コラボ・バケットハット
11164 MOTIONLESS IN WHITE We're Here To Stay Hoodie
37373 Hi-STANDARD×MISHKA EXWDHS01H BEAR GUY PULLOVER WHT
37374 Hi-STANDARD×MISHKA EXWDHS01H BEAR GUY PULLOVER BLK
37379 Hi-STANDARD×MISHKA EXWDHS03H MONSTER PULLOVER BLK
62570 Survive Said The Prophet REDEFINE TOUR HOODIE BLACK
62571 Survive Said The Prophet REDEFINE TOUR HOODIE WHITE
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
56480 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・パーカー WHITE
56481 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・パーカー ORANGE
11162 MEMPHIS MAY FIRE Crest Black Hooded
11169 PROTEST THE HERO Vulture Black Hooded
11205 BLACK VEIL BRIDES Skyline Hoodie Black
15324 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather / Black
15325 CHUNK!NO,CAPTAIN CHUNK! Mustache Heather/Burgundy
15392 ANIMALS AS LEADERS Green Emblem Black Hooded Pullo
15424 ISSUES Logo Heather Hooded
15432 ISSUES Logo Dark Heather Hooded
15433 ISSUES Monster Heather Hoodie
15600 TEXAS IN JULY Gatekeeper Black Hooded Pullover
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19019 WHITECHAPEL Bloody Blade Black
19806 CAPTURE THE CROWN Geisha Heather Hoodie
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
24645 NECK DEEP Flag BlackShooting Eye Black - Pullover
24666 SLEEPING WITH SIRENS Nails Heather Navy - Hooded Sweatshirt
24754 WHITECHAPEL Crate Black - Pullover
36569 SLAYER Pentagram HOODIE
36767 RED HOT CHILI PEPPERS Washed Out Asterisk Hoodie
56907 Unlucky Morpheus×GEKIROCK CLOTHING 限定コラボ・パーカー
56934 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・パーカー BLACK
56935 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・パーカー WHITE
52285 あゆみくりかまき×ゲキクロ×ripdw AKM STAR HOODIE
26230 OPETH Morningrise Hoodie
26268 DESCENDENTS Milo Goes To College Pullover
26294 EMPEROR Logo Shield
51422 GREEN DAY Unisex Pullover Hoodie: Logo & Grenade
28299 UPON A BURNING BODY Horns Black - Pullover
11210 THE FACELESS Autotheism Hoodie Black
11212 I SEE STARS Logo Black Hoodie
70708 Survive Said The Prophet MAKE / BREAK TOUR HOODIE
64473 Zephyren(ゼファレン) BIG PARKA FLOW - Proof - BLACK
11219 OF MICE & MEN Wave Faithfulness Black Hooded
19014 REVOCATION Deathless Album Black
24643 NECK DEEP Generic Pop Punk Red Marble - Pullover
24676 SLEEPING WITH SIRENS Radio Black - Pullover
25135 SEAWAY Colour Blind Logo Grey - Pullover
25225 POLYPHIA Clouds Black - Pullover
25238 BLACK VEIL BRIDES Stitch Black - Pullover
25239 BLACK VEIL BRIDES Swirl Black - Pullover
25484 PIERCE THE VEIL San Diego Navy - Pullover
26291 DROPKICK MURPHYS Shamrock & Roll Pullover
43341 BRING ME THE HORIZON EYE HOODIE
45656 BRING ME THE HORIZON YOU'RE CURSED HOODIE
45665 BRING ME THE HORIZON DYNAMITE HOODIE charcoal
60521 ADAM at×GEKIROCK CLOTHING×KAVANE Clothing スペシャル・コラボ・パーカー
61040 BRIDEAR × GEKIROCK CLOTHING × KAVANE Clothing 限定コラボ・パーカー
61527 Unlucky Morpheus×GEKIROCK CLOTHING 限定コラボ・パーカー NEWカラー OFF-WHITE
61528 Unlucky Morpheus×GEKIROCK CLOTHING 限定コラボ・パーカー NEWカラー GRAY
25185 IWRESTLEDABEARONCE Surf Dracula Multi-Rainbow - Pullover
35558 BRING ME THE HORIZON BANNER HOODIE
35616 GUNS N' ROSES CLASSIC LOGO PULLOVER
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
52507 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) BLACK
52508 BILLIE EILISH UNISEX PULLOVER HOODIE AIRBRUSH FLAMES BLOHSH (BACK PRINT) ORANGE
52592 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO & STAR (APPLIQUE MOTIFS)
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
53185 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: CROWN OF ROSES
56758 GREEN DAY UNISEX HOODIE: AMERICAN IDIOT