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 =393
)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-19 17:08:09')
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 360, 120
9090 PUNK DRUNKERS うにパーカ PURPLE
9245 PUNK DRUNKERS 虫くいジップパーカ RED
10170 Subciety × KINGS ROAD TATTOO -TEPPEI- Navy
11130 REBEL8 STANDARD ISSUE LOGO ZIP UP HOODIE
11159 BLESS THE FALL Anchor Hoodie Black
11161 MEMPHIS MAY FIRE Opportunity Black
11196 Subciety A.V.E.S.T PARKA -LOUD NOISE- CHA
11204 ATTILA Death Is Calling Hoodie Black
11208 ENTER SHIKARI Skankers Hoodie Black
11215 LIKE MOTHS TO FLAMES Demon Black Hoodie
11217 MISERY SIGNALS Absent Light Navy Zip-Up Hoodie
11220 WHITECHAPEL Demon Shield Hoodie Black
11267 BLACK CRAFT Tarot Zip Up Hoodie
11978 ICECREAM L/S BIG TOP FULL ZIP HOODY HTR GRAY
12574 THRASHER Jay Adamus PULLOVER HOODIE PINK
12610 LUCKY13 BLACK CAT FULL ZIP Hoodey
13120 DEADHEARTZ CRESCET HOODIE GRAY
13121 DEADHEARTZ CRESCET HOODIE BLACK
13324 MISHKA (ミシカ) CREEPING DEATH SPLIT ZIP HOODIE BLACK
13513 MISHKA (ミシカ) DEATH DIVISION ZIP HOODIE
13514 RUDIE'S ENOUGH ZIPHOOD SW TURQUOISE
13515 RUDIE'S ENOUGH ZIPHOOD SW BLACK
13516 RUDIE'S ENOUGH ZIPHOOD SW GRAY
13621 DROP DEAD CLOTHING TRENCH DROP HOODIE
13712 NineMicrophones ZIP PARKA -TATTOO MACHINE-BLK/WHT
13727 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/WHT
13728 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-BLK/BGN
13729 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-CGY
13730 NineMicrophones PATCHWORK ZIP PARKA -FIGHT-NAVY
13736 NineMicrophones ZIP PARKA -9MC Crew- BLK/BGN
13737 NineMicrophones ZIP PARKA -9MC Crew- NAVY
13739 NineMicrophones ZIP PARKA -9MC Crew- BLK/WHT
13804 Subciety TIE DYE ZIP PARKA-EMOTION- BGN
13945 Subciety ZIP PARKA-WELL MADE-BLACK/WHITE
13946 Subciety ZIP PARKA-WELL MADE-CHACOAL
13974 GLAMOUR KILLS ACID EYES PULLOVER HOOD GRAY
13976 GLAMOUR KILLS DESTROY EVERYTHING PULLOVER HOOD
13999 RUDIE'S FAR EAST ZIPHOOD SW BLACK
14000 RUDIE'S FAR EAST ZIPHOOD SW GRAY
14001 RUDIE'S FAR EAST ZIPHOOD SW WHITE
14130 Subciety PATTERNED ZIP PARKA-GLORIOUS- BLK/MUS
14132 Subciety PATTERNED ZIP PARKA-GLORIOUS- GREY
14140 DEADHEARTZ GOTHIC HOODIE GRY
14146 RUDIE'S SPARK ZIPHOOD SW BLACK
14148 RUDIE'S SPARK ZIPHOOD SW RED
14154 REBEL8 ANY MEANS BLACK ZIP-UP HOODIE
14236 Subciety EMBROIDERY ZIP PARKA BLACK/TRIBE CROSS
14237 Subciety EMBROIDERY ZIP PARKA CHARCOAL/TRIBE CROSS
14238 Subciety EMBROIDERY ZIP PARKA BLUE/TRIBE CROSS
14287 ROLLING CRADLE BiG CYCLOPS-SB HOODIE / Gray
14311 PUNK DRUNKERS 【PDSxキン肉マン】 ヘルミッショネルズパーカ BLK
14312 PUNK DRUNKERS 【PDSxキン肉マン】 ヘルミッショネルズパーカ NVY
14436 KILL STAR CLOTHING HELL YEAH ZIP HOODIE [B]
14469 Subciety 2015 福袋 25,000
14571 SO SO HAPPY Tribe Hoodie In Blue
14572 SO SO HAPPY iJustine Winkle Pink Limited Edition
14573 SO SO HAPPY Lucky Daisy Hoodie In White
14575 SO SO HAPPY Mens Mix Tape Hoodie In Pink
14576 SO SO HAPPY Tribe Hoodie In Green
14578 SO SO HAPPY QBaller Hoodie In Purple
14579 SO SO HAPPY SIQ Hoodie In Pink and Black
14617 THRASHER BTD HOODIE BLACK
14618 THRASHER BTD HOODIE GRAY
14630 ICECREAM ICECREAM DRIP ZIPUP HOODY
14642 Subciety TRIBAL ZIP PARKA BLACK
14690 THRASHER x KEITH HARING HOODIEBLACK
14703 RUDIE'S TUSK ZIPHOOD SW BLACK/RED
14705 RUDIE'S TUSK ZIPHOOD SW BLACK/WHITE
14736 SABBAT13 CRYPT ZIP-PARKA (BK)
14737 SABBAT13 CRYPT ZIP-PARKA (GY)
14742 NineMicrophones 9MC Loco PARKA CHACOAL
14773 MISHKA (ミシカ) ELEVATED REALM ZIP UP HOODIE
14816 DISTURBIA CLOTHING Storm Hoody
14843 MISHKA (ミシカ) AUTOPS DEATH ZIP UP HOODIE
14857 REBEL8 JOIN OR DIE BLACK PULLOVER
14884 Subciety PATCH WORK PARKA-GLORIOUS- BLK/WHT
14911 MISHKA (ミシカ) CYRILLIC CANNABIS HOCKEY LACED PULLOVER
14948 FAMOUS STARS AND STRAPS REPSTYLIN Pullover GRY
14983 Agape Attire NEVER ALONE HOODIE
14992 RUDIE'S PASTE ZIPHOOD SW BLACK/WHITE
14993 RUDIE'S PASTE ZIPHOOD SW WHITE/BLUE
15013 MISHKA (ミシカ) TANGLED PULLOVER HOODIE
15086 REBEL8 EIGHTERS ZIP-UP HOODIE
15111 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BLK
15112 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA WHITE
15113 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA NAVY
15114 NineMicrophones 9MC SK8 PATTERNED ZIP PARKA BUR
15231 ZEPHYREN (ゼファレン) ZIP PARKA -SKULL HEAD- BLK
15232 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- BLK×BGN
15233 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- GRY
15235 ZEPHYREN (ゼファレン) PARKA -Script- BLK
15238 ZEPHYREN (ゼファレン) PARKA -Script- NVY
15293 REBEL8 WOMENS BANDANA 8 ZIP-UP HOODIE
15330 YELLOWCARD Logo Black Charcoal - Two-Tone Zip-Up
15343 WHITECHAPEL Make It Bleed Black Zip-Up Sweatshirt
15345 WHITECHAPEL Tetanus Black Zip-Up Sweatshirt
15349 WHITECHAPEL Freedom Black - Zip-Up Sweatshirt
15361 KILL STAR CLOTHING OCCULT HOODIE [B]
15371 FINCH Linear Black Zip-Up Sweatshirt
15398 THE DILLINGER ESCAPE PLAN Album Art Black Zip-Up
15403 MEMPHIS MAY FIRE Ordinary Love Black Zip-Up Sweats
15420 DEADHEARTZ ILLUMINATI ZIP UP /BLACK
15452 MOTIONLESS IN WHITE Dracula Black Hooded Zip Up
15463 MOTIONLESS IN WHITE Raven Black
15465 MOTIONLESS IN WHITE Logo Black ZIP HOODIE
15468 BLESS THE FALL Hollow Bodies Black/Grey Zip-Up
15480 ATTILA FTW Black
15516 WE CAME AS ROMANS Hope Black Zip-Up Sweatshirt
15536 MAYDAY PARADE Umbrellas Black
15548 NEW BREED SKULL HOODIE
15560 FAR★STAR 六芒星 パーカー WHT
15561 FAR★STAR 六芒星 パーカー BLK
15564 FAR★STAR ツノ パーカー
15569 FAR★STAR 目苺パーカー
15645 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK
15646 ZEPHYREN (ゼファレン) ZIP PARKA -Determination- BLK×BGN
15649 ZEPHYREN (ゼファレン) PARKA -Determination- BLK
15651 ZEPHYREN (ゼファレン) PARKA -Determination- GRY
15693 KEYTALK GORILLA パーカー
15720 KEYTALK モンスターパーカー BLACK