SELECT SQL_CALC_FOUND_ROWS 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-25 11:14:12')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 120
50355 GALFY 色最高パーカー NAVY
51493 NieR (ニーア) ポケット付総柄ペイント半袖パーカー
8926 THRASHER (スラッシャー) TH8501 MAG LOGO HOODIE BK/GRY
10639 THRASHER TH8501 MAG LOGO HOODIE BRG/WHT
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
52438 SABBAT13 PARADISE HOODIE(ブラック)
52462 GALFY (ガルフィー) 犬パーカー 黒
45387 GALFY 色絶妙パーカー NAVY
50604 GALFY (ガルフィー) 野良犬ダブダブパーカー 青野良犬
52995 SLIPKNOT UNISEX PULLOVER HOODIE: LOGO (BACK PRINT)
53884 MISHKA(ミシカ) MSS200072 HOODIE WHITE
2869 THRASHER TH95130 FLAME MAG LOGO 3C HOODIE BLK/YEL
5934 NineMicrophones 9MC Loco PARKA BLK/WHT
8452 NineMicrophones 9MC Loco PARKA BLK/BRG
10608 MISHKA (ミシカ) HELLA STUFF PULLOVER WHITE
10788 DROP DEAD CLOTHING AK'S PULLOVER HOODY
11131 REBEL8 STANDARD ISSUE LOGO PULLOVER
11160 MEMPHIS MAY FIRE Shield Heather Hooded
11162 MEMPHIS MAY FIRE Crest Black Hooded
11164 MOTIONLESS IN WHITE We're Here To Stay Hoodie
11169 PROTEST THE HERO Vulture Black Hooded
11205 BLACK VEIL BRIDES Skyline Hoodie Black
11210 THE FACELESS Autotheism Hoodie Black
11212 I SEE STARS Logo Black Hoodie
11219 OF MICE & MEN Wave Faithfulness Black Hooded
11268 BLACK CRAFT Lone Wolf Hooded Pullover Sweater
11765 REBEL8 FIGHT THE POWER BLACK PULLOVER
12153 SPITFIRE BIGHEAD Pullover hoodie GRAY
12571 THRASHER SILVER FLAME LOGO PULLOVER HOODIE GRAY
13411 ICECREAM LUX CONE PULLOVER GRAY
13412 ICECREAM CONE BAR PULLOVER BLACK
13780 RUDIE'S STITCH GIRLS PULLOVER SW BLACK
13799 Subciety TIE DYE PARKA-GLORIOUS- GRAY
13800 Subciety TIE DYE PARKA-GLORIOUS- BGN
13801 Subciety TIE DYE PARKA-GLORIOUS- GREEN
13802 Subciety TIE DYE ZIP PARKA-EMOTION- NAVY
13803 Subciety TIE DYE ZIP PARKA-EMOTION- GRAY
13911 RUDIE'S BIG-R HOOD SW GRAY
13915 RUDIE'S BIG-R HOOD SW BLACK
14139 DEADHEARTZ LOGO HOODIE BLK
14156 DEADHEARTZ GOTHIC LOGO HOODIE NAVY
14157 DEADHEARTZ CRESCET HOODIE Burgundy
14222 FAMOUS STARS AND STRAPS STRIKER BOH PULLOVER BLK
14228 FAMOUS STARS AND STRAPS FAMILY PULLOVER HOODY GLY
14229 FAMOUS STARS AND STRAPS FAMILY PULLOVER HOODY BLUE
14276 THRASHER TH8501 MAG LOGO HOODIE WHITE/BLACK
14388 アマツカミ Moon Box Hoodie
14389 アマツカミ Mice Manji Hoodie
14565 SQUARE POLKA DOTS HOODY BLACK
14619 SQUARE BIG LOGO HOODIE GRAY
14620 SQUARE BIG LOGO HOODIE BLACK
14741 NineMicrophones 9MC Loco PARKA NAVY
14758 KILL STAR CLOTHING DOLLAR PULLOVER HOODIE [B]
14947 FAMOUS STARS AND STRAPS Gang Bar BOH Mens Zip
15028 DROP DEAD CLOTHING Anti-Social Hoodie
15077 REBEL8 RIBBON FLOW BLACK PULLOVER
15105 GLAMOUR KILLS STAR GAZER PULLOVER
15192 PUNK DRUNKERS 300ミリオンパーカ PURPLE
15236 ZEPHYREN (ゼファレン) PARKA -Script- BLK×BGN
15237 ZEPHYREN (ゼファレン) PARKA -Script- GRY
15239 ZEPHYREN (ゼファレン) PARKA -VISIONARY- BLACK
15241 ZEPHYREN (ゼファレン) PARKA -VISIONARY- GRY
15244 ZEPHYREN (ゼファレン) PARKA -BEYOND- BLK×GLD
15266 ICECREAM ICECREAM STOKED PULLOVER
15283 REBEL8 WOMENS JOIN OR DIE PULLOVER
15288 REBEL8 WOMENS RIBBON FLOW PULLOVER
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
15503 MISHKA (ミシカ) Autopsy Slack Hoodie Black
15530 ICECREAM RUNNING DOG PINK GREEN
15600 TEXAS IN JULY Gatekeeper Black Hooded Pullover
15650 ZEPHYREN (ゼファレン) PARKA -Determination- BLK×BGN
15789 ROLLING CRADLE SD ROLICLE HOODIE / Black
15812 BLACK CRAFT Lucipurr - Hooded Pullover Sweater
15974 ZEPHYREN (ゼファレン) PARKA -NEVER DESPAIR NAVY
16367 BLACK CRAFT Baphomet 666 - Hooded Pullover Sweater
16503 Subciety PARKA-Parantica sita- BURGUNDY
16508 Subciety PARKA-LARGE GLORIOUS- BLACK
16510 Subciety PARKA-LARGE GLORIOUS- CHARCOAL
16595 KILL STAR CLOTHING RITUAL HOODIE [B]
16689 Subciety PARKA-PATTERNED ALL OVER- GRAY
16718 ICECREAM CONES & BONES ALL OVER PULLOVER
16844 ZEPHYREN (ゼファレン) PARKA -THE SUN- BLACK
16845 ZEPHYREN (ゼファレン) PARKA -THE SUN- BLK/BGN
16848 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- BLACK
16849 ZEPHYREN (ゼファレン) PARKA -RAMPAGE- GRAY
16853 ZEPHYREN (ゼファレン) ZIP PARKA -RAMPAGE- BLACK
16943 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- BLACK
16945 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- NAVY
16946 ZEPHYREN (ゼファレン) S/S HOODY -SKULL HEAD- GRAY
17457 Famous Stars And Straps Men's Dark Cloud Raglan
17500 DROP DEAD CLOTHING Cod-eyed Hoodie
17589 ZEPHYREN (ゼファレン) PARKA -Never Despair- BLK/BGN
17930 アマツカミ うそつき Hoodie
17950 KILL STAR CLOTHING OUIJA HOODIE [B]
18040 四星球 MMM4パーカー
18428 Subciety PARKA-GLORIOUS- - NAVY/WHITE
18429 Subciety PARKA-SALOON- - BLACK/RED
18432 Subciety PARKA-SALOON- - NAVY/RED
18433 Subciety PARKA-New Jack- BLACK/WHITE
18435 Subciety PARKA-New Jack- CHARCOAL/NAVY
18717 NineMicrophones PARKA -RUN 9MC- BLACK
18732 NineMicrophones 9MC Loco PARKA NAVY
18733 NineMicrophones 9MC Loco PARKA GRAY
18982 MEMPHIS MAY FIRE No Ordinary Love Heather Charcoal
19014 REVOCATION Deathless Album Black
19019 WHITECHAPEL Bloody Blade Black
19367 ZEPHYREN (ゼファレン) FLEECE STRIPE PARKA -Resolve - BLACK
19382 ZEPHYREN (ゼファレン) SUBLIMATION PARKA - BLK VOID
19408 ZEPHYREN (ゼファレン) TIE DYE PARKA -VISIONARY - NAVY
19529 Zephyren PARKA -EMBLEM - BLACK×BLACK
19530 Zephyren PARKA -EMBLEM - GRAY
19806 CAPTURE THE CROWN Geisha Heather Hoodie
19855 OF MICE & MEN Text Heather Athletic Grey Hooded S.
20064 ICECREAM VARSITY PULLOVER BLACK
20189 REBEL8 EIGHTH OMEN GREY HEATHER