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 =1
)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 12:57:04')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.stock > 0
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 240, 120
63443 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE WHITE
63446 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee WHITE
63364 KEYTALK【Disney】Tシャツ (ステージ) WHITE
61867 glamb (グラム) Military Remake CS - White×Khaki
61853 A FEW GOOD KIDS ICECREAM TEE WHITE
61436 glamb (グラム)×攻殻機動隊 SAC_2045 T White
61419 VIRGO (ヴァルゴ) GLOWING EYES WHITE
60165 Anti Social Social Club THE REAL ME WHITE TEE
61207 XrossOver XOver K logo T (White)
60048 SAMURAI CORE リンガーTEE BLUE
60047 SAMURAI CORE リンガーTEE RED
60049 SAMURAI CORE リンガーTEE BLACK
56038 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE WHITE
54527 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE WHITE
53149 SAMURAI CORE 釈迦 TEE WHITE
60240 acOlaSia VICTIM TEE WHITE
60246 acOlaSia MEDAMAYAKI TEE WHITE
60127 HYPER CORE HTC-372 ぴえんICE BEAR Tシャツ WHITE
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
59955 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE WHITE
58461 Subciety×NARUTO-ナルト- 疾風伝 NARUTO S/S WHITE
59405 SUPPLIER (サプライヤー) SPIDER WEB TEE
15225 ZEPHYREN (ゼファレン) TEE S/S -BEYOND- WHT
59233 LONELY論理 LONELY UNIV TEE white
59117 ANIMALIA AN21U-TE11 FALLING WHITE
58789 HYPER CORE PINK SNIPER Tシャツ WHITE
58813 HYPER CORE PiSTOLTシャツ WHITE
58165 NOT COMMON SENSE DEAD TUDE TEE WHITE
57322 Subciety×仮面ライダードライブ DRIVE S/S WHITE
57306 HEDWiNG Pocket “MOJYAPON” T-shirt White
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
57384 FILA FS3028 T-Shirt WHITE
57390 FILA FS3008 T-Shirt WHITE
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
56210 Anti Social Social Club Enrique White Vneck Tee
56213 Anti Social Social Club Headrush All Over White Tee
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
48288 Subciety (サブサエティ) SUKA SOUVENIR S/S WHITE
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
10261 RANCID MONSTER PRINT T-Shirt
15430 THE WORD ALIVE Press Photo White T-Shirt
15466 CHIODOS Chaos White T-Shirt
15513 WE CAME AS ROMANS My Home Your Heart White
15540 MAYDAY PARADE Ghosts Lyric White GIRLS Shirt
15886 フクザワ 飼われ男 Tシャツ
15982 PAN マスコロ'14オフィシャルTシャツ×HABIT DESIGN WHITE
16714 ICECREAM CONES&BONES T-SHIRT T04 WHITE
17655 ICECREAM RUNNING DOG GLOW IN THE DARK WHITE
18987 WE CAME AS ROMANS Howl At The Moon White
19104 ATTILA RAGEAHOLICS WHITE
19867 BREATHE CAROLINA Savages Album White T-Shirt
19919 LIVEHOLIC GRAND OPENING SERIES Limited T-Shirt WHT
20127 激ロック×サボパン【激サボパンTシャツ】 WHITE
20170 FUZZ REZ ZWEEP DELAY TEE WHT
21083 フクザワ あの日のこと Tシャツ
21087 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT WHT
21140 BEFORE MY LIFE FAILS NEW LOGO TEE WHITE
21969 セプテンバーミー ユーレイTシャツ 白
21990 THREE LIGHTS DOWN KINGS FIRE T-Shirts WHITE
22103 FUZZ REZ ZWEEP BIT CRUSHER TEE WHT
22541 SANTA CRUZ SIEBEN HAND S/S T SHIRT WHITE
22586 I THE BREATHER SERCH FOR A BETTER LIFE
22588 WATCHOUT! THERES GHOSTS MONSTER TEE
22611 Bentham cokeTシャツ WHT
22664 ICECREAM BOXED DOG.TEE WHT/PP
22703 5 SECONDS OF SUMMER Jet Black Heart Tee
22719 ザ・チャレンジ カラフルBOXロゴ Tシャツ WHT
23467 ICECREAM ICJP16T001 WHT
23747 9mm Parabellum Bullet Photo Tシャツ
23856 FOUR GET ME A NOTS Chie Tシャツ
23928 a flood of circle AFOC LOGO TEE WHT
24348 ICECREAM ICJP16T006 WHT
24349 ICECREAM EVIL SUNDAE TEE
24892 NORTHLANE Terence White - T-Shirt
24899 ANIMALIA GOLD WEST WHT
25009 THE STORY SO FAR Snake Girl White - T-Shirt
25158 WE CAME AS ROMANS TROY White - T-Shirt
25162 WE CAME AS ROMANS Bombs White
25264 A SKYLIT DRIVE Hangin' So Loose White - T-Shirt
25415 I SEE STARS Old Dude
25488 SECRETS Flag White - T-Shirt
25492 THE SUMMER SET Perfectly Wasted Youth White - T-Shirt
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
28349 フクザワ 白昼夢 Tシャツ
28364 ALL OFF リアルフクロウT-shirt White
29197 Subciety (サブサエティ) PAISLEY JACQUARD P/O S/S OFF_WHITE
31953 Bentham ExPツアーTシャツ WHITE
36829 DISTURBED Ravens Jumbo Print-White t-shirt
39163 BLACK SABBATH LOTW white Tee
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
41078 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / PINK
41079 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボTシャツ 2018 WHITE / BLACK
42666 夢みるアドレセンス"メロンソーダ" 限定Tシャツ
47105 NOT COMMON SENSE GENESIS SEAM TEE WHITE
49205 ZERO EVOKE Show Time Tee (WHITE)
50185 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee WHITE
51445 JILUKA×DI:VISION ゲキクロ・コラボ・Tシャツ WHITE
52286 あゆみくりかまき×ゲキクロ×ripdw AKM TIMES T-SHIRT
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54615 Survive Said The Prophet TAPED LOGO TEE WHITE