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 09:49:34')
AND FIND_IN_SET(2, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70787 SCENE TOKYO (シーントウキョウ)PPL girl zip hoodie ash
70072 NineMicrophones(ナインマイクロフォンズ) ZIP PARKA-Pray with the microphone- GRAY
69034 GALFY (ガルフィー) 染め染めわんちゃんボロボロパーカー GREIGE
69641 GALFY (ガルフィー) 染め染めデスメタルにゃんにゃんパーカー GREIGE
69053 GALFY (ガルフィー) ガルドッグスジップパーカー GRAY
69485 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM ZIP HOODIE GRAY
69491 Subciety (サブサエティ) EMBROIDERY MARIA ZIP PARKA GRAY
67392 TheBackOfBoys(ザバックオブボーイズ) Cute Girl Zip Hoodie Type1ASH
67394 TheBackOfBoys(ザバックオブボーイズ) Cute Girl Zip Hoodie Type2 ASH
67405 愛本りんく × RUDIE'S コラボ限定ジップアップパーカー
67871 桔梗凛生× AFFECTER コラボ限定ジップアップパーカー
67745 DI:VISION (ディヴィジョン) SHED ZIP HOODIE GRAY
67792 MISHKA (ミシカ) INFINITE PAIN ZIP-UP HOODIE MIDZH-01 GRAY
67458 RUDIE'S(ルーディーズ) SHADOW LOGO ZIP PARKA SGY
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61271 Zephyren 2022 NEW YEAR BAG
66460 NineMicrophones (ナインマイクロフォンズ) ZIP PARKA-9MC Loco- GRAY
63928 VIRGO(ヴァルゴ)MILSPEC LOOSE HOODIE BEIGE-CHARCOAL
61746 RIP DESIGN WORXX ハイドジップパーカー GRAY
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
59434 Zephyren(ゼファレン) PARKA - MY FIRST STORY 10th Anniversary - GRAY
50010 【バンドリ!×ゲキクロ 第3弾復刻】RideMe×青葉モカ コラボ 限定 パーカー
55876 GoneR GR26ZP001 Rose Photo Zip Parka Heather gray
11196 Subciety A.V.E.S.T PARKA -LOUD NOISE- CHA
11978 ICECREAM L/S BIG TOP FULL ZIP HOODY HTR GRAY
13516 RUDIE'S ENOUGH ZIPHOOD SW GRAY
13946 Subciety ZIP PARKA-WELL MADE-CHACOAL
14000 RUDIE'S FAR EAST ZIPHOOD SW GRAY
14140 DEADHEARTZ GOTHIC HOODIE GRY
14237 Subciety EMBROIDERY ZIP PARKA CHARCOAL/TRIBE CROSS
15233 ZEPHYREN (ゼファレン) ZIP PARKA -Skull head- GRY
15330 YELLOWCARD Logo Black Charcoal - Two-Tone Zip-Up
15468 BLESS THE FALL Hollow Bodies Black/Grey Zip-Up
16500 Subciety ZIP PARKA-Parantica sita- CHARCOAL
16507 Subciety ZIP PARKA-LARGE GLORIOUS- CHARCOAL
16545 DROP DEAD CLOTHING Throw On Hoodie Gray
16686 Subciety ZIP PARKA-PATTERNED ALL OVER- GRAY
16692 NineMicrophones ZIP PARKA-NINE BONES- GRAY
16842 ZEPHYREN (ゼファレン) ZIP PARKA -THE SUN- GRAY
18726 NineMicrophones ZIP PARKA -9MC Crew- GRAY
19371 ZEPHYREN (ゼファレン) TIE DYE TRIBAL ZIP PARKA GRAY
19401 Zephyren (ゼファレン) EMBROIDERY PARKA L/S - GRY/Charmed SQ Tone
19509 Zephyren ZIP PARKA -EMBLEM - GRAY
20606 MISHKA (ミシカ) KEEP WATCH CREST ZIP UP HOODIE
20729 Subciety (サブサエティ) ZIP PARKA-Praha- GRAY
21229 ROLLING CRADLE RLCR-PATCH ZIP HOODIE / Gray
21557 DEADHEARTZ "BLOOD"ZIPUP HOODIE GRAY
21754 ICECREAM DRIP ZIPUP HOODY GREY/BLUE
22509 SABBAT13 ARCH ZIP-PARKA (GY)
22571 Zephyren (ゼファレン) SWITCHING LONG ZIP PARKA -Resolve- CHACOAL x CHECK
22642 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO I
22643 Zephyren (ゼファレン) TIE DYE CAMOUFLAGE ZIP PARKA -Resolve- CAMO II
22688 RIP DESIGN WORXX ピザジップアップパーカーグレー
22889 Zephyren (ゼファレン) THRASHER x Zephyren ZIP PARKA -PENETRATE- GRAY
23370 DEADHEARTZ D ZIP HOODIE /GRAY
23953 LILWHITE. -CIRCLE-ZIP HOODIE GRY
23982 ANIMALIA AN16U-SW02 ZIP UP HOODIE #002 OATMEAL
24716 Zephyren (ゼファレン) SWITCHING NOSLEEVE LONG PARKA -Resolve- CHACOAL x PAISLEY
24759 WHITECHAPEL Hypocrisy Heather Gray - Zip-Up Sweatshirt
25978 NineMicrophones (ナインマイクロフォンズ) Light ZIP PARKA-Fight back- GRAY
27114 Zephyren (ゼファレン) BIG HOOD PARKA -Resolve- GRAY
27127 Zephyren (ゼファレン) LONG ZIP PARKA -SPADE- GRAY
27159 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -SPADE- GRAY
27172 Zephyren (ゼファレン) LIGHT WEIGHT PARKA -Ace of spades- GRAY
27196 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -BEYOND- GRAY
27201 Zephyren (ゼファレン) HEAVY WEIGHT ZIP PARKA -SPADE- GRAY
27447 BLACK SCALE LOCKDOWN ZU GREY
27932 LILWHITE. (リルホワイト) -F/B-ZIP UP HOODIE GRY
28432 RUDIE'S DRAWING ZIPHOOD SWEAT GRY
28759 BLACK SCALE BLVCK REBELS ZIP HOODIE GREY
28765 VIRGO SWITCHING SPORTS HOOD BK-GYhood
28766 VIRGO SWITCHING SPORTS HOOD GRY-BLK
28820 RIP DESIGN WORXX ロゴジップアップパーカーグレー
28965 PUNK DRUNKERS スワットパーカ GRAY
29015 SQUARE ARM PRINT ZIPUP LIGHT HOODY GRAY
29594 VIRGO FRAGMENT MONSTER PARKA GRAY
29696 SABBAT13 GLOOMY HUMMING ZIP-PARKA GREY
29698 SABBAT13 MORTAL ZIP-PARKA GREY
29728 THRASHER THKH-ZHD10 ZIP HOODIE GRAY
29753 SABBAT13 HAND MONSTER "VAMP" ZIP-PARKA (GY)
29755 SABBAT13 HAND MONSTER "FRANK" ZIP-PARKA (GY)
29948 SABBAT13 MESSAGE from IGOR L/L ZIP-PARKA GRAY
30265 Zephyren(ゼファレン) LIGHT WEIGHT ZIP PARKA -ENGRAVE- GRAY
30415 Zephyren(ゼファレン) STUDS ZIP PARKA GRAYxSILVER
31719 DISTURBIA CLOTHING Situationist Hoody
31881 LILWHITE(dot) (リルホワイトドット) -ICONIC- FRONT ZIP HOODIE GRAY
31961 DEADHEARTZ HELL ZIP HOODIE GRAY
32072 PUNK DRUNKERS 目ん玉ウルフパーカ GRAY
32359 REBEL8 TOAST TO THE WORST ZIP-UP HOODIE
32557 VIRGO Fortress Big Hood Parka GRAY
33038 SPITFIRE CIRCLE ZIP HOODIE GUNMETAL HEATHER
34425 AA= #5 JACKET PARKA
34623 Subciety (サブサエティ) ZIP PARKA-STANDARD- GRAY
34625 Subciety (サブサエティ) ZIP PARKA-REASON- GRAY
34964 SABBAT13 MORTAL ZIP HOODIE (グレー) GRAY
36139 PUNK DRUNKERS NEETスウェットパーカ - M.GRAY
37511 RUDIE'S COLLEGE HIGHNECK ZIPHOOD SWEAT GRAY
37842 Xmas Eileen DIS IS LOVEパーカー(グレー)
38144 RUDIE'S BRILLIANT GALAXY ZIPHOOD SWEAT GRAY
38632 THRASHER TH8601FT MAG FRENCH TERRY ZIP HOODIE GRAY
38741 THRASHER TH8602Z HOMETOWN ZIP HOODIE GRAY
38926 DEADHEARTZ growth devil ZIP Hoodie GRAY
38962 SPITFIRE STOCK BIGHEAD HUMBLE ZIP HOODIE
38994 LiSA × GoneR Long Parka Grey
39387 ROLLING CRADLE RC×B&B HOODIE "TV FREAK" GRAY
39389 ROLLING CRADLE RC×B&B HOODIE "BEAVIS CORNHOLIO" GRAY
39516 SABBAT13 HAND OF GLORY ZIP HOODIE (GY)
41059 OBEY x Misfits Fiend Club Zip Hood GRAY
41499 NineMicrophones ZIP PARKA-Sing- GRAY
42473 SABBAT13 SBT-PK-027 13X-BONE ZIP HOODIE(ヘザーグレー)
42475 SABBAT13 SBT-PK-028 CRYPT ZIP HOODIE(ヘザーグレー)
42810 SLEEPING TABLET MOON ZIPHOOD GRAY
43449 THRASHER TH5062 Zip Hoodie GRAY
43514 PARADOX PX14-PK01 ZIP PARKA C.GRAY
44028 SANTA CRUZ EDGE DPT LS HODED GRAY
45224 NineMicrophones ZIP PARKA-Way of Life- GRAY
45551 Subciety (サブサエティ) ZIP PARKA-Primal- GRAY
45977 Zephyren(ゼファレン)ZIP PARKA -alea iacta est / milestone- GRAY