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 =6
)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 08:09:56')
AND FIND_IN_SET(22, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
69717 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BROWN
69715 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET BLACK
69716 TOY MACHINE (トイマシーン) SECT EYE PATCH PLAID CHECK ZIP SHACKET RED
70598 over print (オーバープリント) Rebirth shirts etc A-8
70592 over print (オーバープリント) Rebirth item B-14
70597 over print (オーバープリント) Rebirth shirts etc A-7
70263 VIRGO(ヴァルゴ) PARALLEL SHIRT RED
69616 ROLLING CRADLE (ローリングクレイドル) CANDY CHECK SHIRT / BLUE-YELLOW
64104 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GREEN
64103 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] GRAY
64102 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] BLACK
64105 SLEEPING TABLET(スリーピング・タブレット) CRYPTO [ NEL CHECK SHIRTS ] PURPLE
65295 山手 響子×RIPDW コラボ 限定 L/Sシャツ
61271 Zephyren 2022 NEW YEAR BAG
60560 MISHKA M61000251 CHECK SHIRT
65889 over print(オーバープリント) Crochet knitting Shirts (renga)
65890 over print(オーバープリント) Crochet knitting Shirts (black)
65888 over print(オーバープリント) Crochet knitting Shirts (cream)
65859 ROLLING CRADLE(ローリングクレイドル) CHECK SHIRT / MULTI
63594 glamb (グラム) Heavy Damaged SH - Blue
63593 glamb (グラム) Heavy Damaged SH - Black
63386 Anti Social Social Club Dialtone Black Tie Dye Flannel
63384 Anti Social Social Club Dialtone Olive Tie Dye Flannel
63385 Anti Social Social Club Chromey Red Tie Dye Flannel
63151 over print (オーバープリント) check shirts (black * blue)
52480 【バンドリ!×ゲキクロ 第4弾復刻】ZEPHYREN×氷川 日菜コラボ 限定 L/S シャツ
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
60868 NieR (ニーア) OFF-SHOULDER GREEN CHECK SHIRT【ベルト付き】
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
60545 ROLLING CRADLE HOOD CHECK SHIRT / YELLOW
60546 ROLLING CRADLE HOOD CHECK SHIRT / BLACK
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
56859 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” RED CHECK
58303 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] PINK
58304 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] BLACK
58305 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] GRAY
58316 RIP DESIGN WORXX Rest in Punk レディースチェックシャツ BLACK
58310 ROLLING CRADLE BIG CHECK SHIRT / BEIGE
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
57123 SABBAT13 BLACK HEART CHECK SHIRTS BEIGE
57125 SABBAT13 BLACK HEART CHECK SHIRTS GRAY
58108 MISHKA M21000251 SHIRT
56857 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” BLACK CHECK
56858 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” GRAY CHECK
53166 RIP DESIGN WORXX クロスドルーズシャツ CLAZY CLOWN
53167 RIP DESIGN WORXX クロスドルーズシャツ CHICANO BLACK
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
54784 PUNK DRUNKERS [PDSxTHUNDERBOX]ピクトグラムシャツ - BEIGE/BROWN
54800 PUNK DRUNKERS オタネルシャツ - ORANGE
55532 HEDWiNG Big Silhouette Plaid Shirt
54212 SLEEPING TABLET M [ FRAYED HEM LOOSE SHIRTS ] GREEN
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
55013 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - GREEN
56033 PARADOX PRINTED CHECK SHIRTS (BLUE)
55632 Anti Social Social Club FRANTIC RED FLANNEL
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
13511 MISHKA (ミシカ) CITY JACK BUTTON UP RED
15211 ZEPHYREN (ゼファレン) EMBROIDERY SHIRT -Charmed- GRAY/CHECK
15842 ROLLING CRADLE SWALLOW TAIL SHIRTL / Gray/Red
15843 ROLLING CRADLE SWALLOW TAIL SHIRTL / Black/Yellow
15844 ROLLING CRADLE RAKURAI LONG NEL / Red
15898 Subciety CHECK SHIRTS L/S-Conductor- GRAY
16663 ROLLING CRADLE POP-ART CRAZY SHIRT / BigCrazy
16664 ROLLING CRADLE POP-ART CRAZY SHIRT / SmallCrazy
18739 NineMicrophones CHECK SHIRTL/S -Comrade- BLACK
19306 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve - WHITE
19308 ZEPHYREN (ゼファレン) CHECK SHIRT L/S -Resolve - BURGUNDY
20417 DROP DEAD CLOTHING Peace Off! Shirt
20665 Subciety CRAZY CHECK SHIRT L/S-Praha- BLACK
20666 Subciety CRAZY CHECK SHIRT L/S-Praha- GREEN
20669 Subciety GINGHAM CHECK SHIRT L/S-GLORIOUS- WHITE
21785 PUNK DRUNKERS カーネルシャツ BW/GRAY
21786 PUNK DRUNKERS カーネルシャツ BLUE/NAVY
22147 Subciety HEAVY FLANNEL SHIRT-GLORIOUS- WHITE
22590 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- NAVY
22591 Zephyren (ゼファレン) CHECK SHIRT L/S -Resolve- BLACK
22955 ROLLING CRADLE RAKURAI BIG SHIRT / White-Navy
22956 ROLLING CRADLE RAKURAI BIG SHIRT / Navy-Red
25646 Subciety DOBBY CHECK SHIRT L/S-Praha- BURGUNDY
25647 Subciety DOBBY CHECK SHIRT L/S-Praha- KHAKI
25648 Subciety OMBRE CHECK SHIRT L/S-THRON- BLACK
25649 Subciety OMBRE CHECK SHIRT L/S-THRON- RED
25650 Subciety OMBRE CHECK SHIRT L/S-THRON- MUSTARD
25667 Subciety BACK ZIP LONG SHIRT-CHECK- BLACK
26003 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- BLACK
26004 NineMicrophones OMBRE CHECK SHIRTL/S-Comrade- RED
26007 NineMicrophones CHECK SHIRT L/S-9MC Crew- RED
26008 NineMicrophones CHECK SHIRT L/S-9MC Crew- GREEN
26710 Zephyren (ゼファレン) EMBLEM SHIRT L/S CHECKⅠ
26711 Zephyren (ゼファレン) EMBLEM SHIRT L/S CHECKⅡ
27079 Zephyren (ゼファレン) LONG CHECK SHIRT -Resolve- WHITE
27080 Zephyren (ゼファレン) LONG CHECK SHIRT -Resolve- BLACK
27082 Zephyren (ゼファレン) LONG CHECK SHIRT -Resolve- RED
27355 SQUARE 4/3 CHECK SHIRTS RED CHECK
27356 SQUARE 4/3 CHECK SHIRTS BLUE CHECK
28667 ROLLING CRADLE RAKURAI NEL NAVY
28671 ROLLING CRADLE RAKURAI NEL RED
28735 Zephyren (ゼファレン) SHADOW CHECK SHIRT L/S -Resolve- BLACK
28736 Zephyren (ゼファレン) SHADOW CHECK SHIRT L/S -Resolve- BROWN
28760 VIRGO 90S PSYCO SHIRTS BLACK
28762 VIRGO 90S PSYCO SHIRTS YELLOW
28865 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Red
28866 ROLLING CRADLE (ロリクレ) RAKURAI LONG NEL / Navy
28897 ROLLING CRADLE GRAVY BIG SHIRTS / Black
28903 RUDIE'S PHAT CHECK SHIRTS RED
28904 RUDIE'S PHAT CHECK SHIRTS BLUE
28943 SABBAT13 IGOR NEL SHIRTS GRAY
28944 SABBAT13 IGOR NEL SHIRTS GREEN
28954 PUNK DRUNKERS カメネルシャツ BLUE
28955 PUNK DRUNKERS カメネルシャツ ORANGE
28956 PUNK DRUNKERS カメネルシャツ RED
28957 PUNK DRUNKERS カメネルシャツ PURPLE
28998 MISHKA (ミシカ) Brock Check Shirt Black/Gray
28999 MISHKA (ミシカ) Check Shirt Red
29000 MISHKA (ミシカ) Check Shirt Blue
29068 PUNK DRUNKERS ドロドロングシャツ長袖 BLACKチェック
29094 SILLENT FROM ME LINT -Wide Flannel Shirts-
29412 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLACK