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 =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-30 21:29:00')
AND FIND_IN_SET(22, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
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
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
61271 Zephyren 2022 NEW YEAR BAG
60560 MISHKA M61000251 CHECK SHIRT
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-
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
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
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
54784 PUNK DRUNKERS [PDSxTHUNDERBOX]ピクトグラムシャツ - BEIGE/BROWN
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
29413 NineMicrophones (ナインマイクロフォンズ) DOLMAN SLEEVE SHIRT 5/S-Comrade- BLUE
29918 REBEL8 HARSH REALM FLANNEL
30018 SQUARE (スクエア) HOOD CHECK SHIRTS BLUE×RED
30020 SQUARE (スクエア) HOOD CHECK SHIRTS GREEN×YELLOW
30063 DISTURBIA CLOTHING Melvin Plaid Shirt
30086 【予約商品】MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT WHITE
30087 MUSIC SAVED MY LIFE (MSML) FLANNEL GOWN SHIRT YELLOW
30216 Zephyren(ゼファレン) LONG CHECK SHIRT L/S RED
30217 Zephyren(ゼファレン) LONG CHECK SHIRT L/S WHITE
30218 Zephyren(ゼファレン) LONG CHECK SHIRT L/S BLACK
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
32310 VIRGO Variable change shirts 切り替えチェックシャツ WHITE
32322 REBEL8 WWD FLANNEL
35761 Zephyren (ゼファレン) BANDANA CHECK SHIRT L/S -Inhale the black- GREEN