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 =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-05-18 10:34:40')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(3, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 360, 120
21481 アーバンギャルド 水玉セーラーT 黒
49835 LINKIN PARK Mark Mask-White t-shirt
49838 LINKIN PARK Dazed-White t-shirt
23747 9mm Parabellum Bullet Photo Tシャツ
10273 IRON MAIDEN OVERSIZED TROOPER Large Print T-Shirt
10430 THRASHER (スラッシャー) TH8101 Mag LogoTee WH/BK
15323 CHUNK!NO,CAPTAIN CHUNK! Floral White/Black
28412 THRASHER TH9105 NECKFACE TEE WHT
35617 GUNS N' ROSES SLASH 1985 RAGRAN
36535 BRING ME THE HORIZON Can't Drown-White
42574 RED HOT CHILI PEPPERS BY THE WAY DISTRESSED LOGO TEE
42576 RED HOT CHILI PEPPERS CLASSIC ASTERSIK TEE
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
54043 THRASHER (スラッシャー) FLAME LOGO S/S TEE WHITE
54642 THRASHER TH8177A S.A.D Tee WHITE
55680 RIP DESIGN WORXX アンノウンクラウンTシャツ WHITE
58321 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT WHITE
58326 THRASHER TH91291 40TH T-SHIRT WHITE
59294 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts White/Green
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
70715 Survive Said The Prophet MAKE / BREAK TEE (WHITE)
56933 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・Tシャツ WHITE
65293 ハッピーハンバーグ ステーキハウス刺繍Tシャツ WHITE
41581 MOTORHEAD×LAKAI War Pig Tee White
49848 REFUSED SHAPE OF PUNK TO COME
54429 【BTS着用モデル】 FILA FFM9357 T-shirts OffWhite
55682 RIP DESIGN WORXX シャドウイーグルTシャツ WHITE
55702 RIP DESIGN WORXX ラウダーロゴビッグプリントTシャツ WHITE
63437 BAD BOY (バッドボーイ) PARODY LOGO PRINT TEE WHITE
63440 BAD BOY (バッドボーイ) 00'S GRAPHIC EMBROIDERY TEE WHITE
63443 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE WHITE
63446 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee WHITE
63818 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE WHITE
63822 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE WHITE
64214 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - WHITE
64218 TOY MACHINE×PUNK DRUNKERS SECT FROM AITSU SS TEE - WHITE
64363 TRAVAS TOKYO【トラバストーキョー】Rhinestone Angel bear BIG H/S Tee White
35490 RUDIE'S (ルーディーズ) SPARK-T WHT/BLK
35693 NIRVANA Kurt Cobain Smoking Box Photo T-Shirt
35704 RED HOT CHILI PEPPERS LED Asterisk t-shirt White
54147 GoneR Ernesto Skull T-Shirts White
54151 GoneR Rose Logo T-Shirts White
54155 GoneR Thunderbird T-Shirts White
54159 GoneR Day of the Dead T-Shirts White
55557 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE WHITE
55847 PSYCHOLOGICAL METAMORPHOSIS MARK LOGO SS TEE WHITE
55850 GoneR × MODERNPIRATES Collaboration T-Shirts White
58692 GoneR GR29CT001 Mexican Round Design T-Shirts White
58696 GoneR GR29CT002 Square Mexican Skull T-Shirts White
58753 東京初期衝動×GEKIROCK CLOTHING コラボ・Tシャツ WHITE
58755 東京初期衝動×GEKIROCK CLOTHING コラボ・レディースTシャツ WHITE
59098 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO TEE WHITE
62856 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. TEE 05 - WHITE
68102 over print(オーバープリント) Circle Tee (white)
39161 MOTORHEAD Everything Louder Raglan Tee
64208 kirou school (キロウスクール) krs_00 arch logo S/S T-shirts WHITE×RED
64209 kirou school (キロウスクール) krs_00 arch logo S/S T-shirts WHITE×GREEN
65291 ハッピーハンバーグ レーシングチームTシャツ WHITE
50622 PassCode THE DAY WITH NOTHING TEE(WHITE)
58759 NieR (ニーア) BIG SIZE T-SHIRT【FACE】
63662 Gluttonous Slaughterr(グラトナススローター) Nyangoro the Fishmonger 解体猫ニャンゴロウ T-shirt
64328 NieR (ニーア) 超BIG SILHOUETTE CUTSEW【broken heart】
64856 Wall Of Graphic(ウォールオブグラフィック)リアム2 Tシャツ
68295 NieR (ニーア) ドライシルキータッチBIGカットソー【WHITE FACE LOGO】
71303 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MAGICAL MOSH MISFITS TEE WH/DOKU
11248 PROTEST THE HERO Crest White
24558 PROTEST THE HERO Knee Face Silver - T-Shirt
69141 gibous(ギボス) skull snake short t shirt WHITE
19851 【ゲキクロ限定カラー】DIAWOLF FLOWER&SKULL DW T-Shirt - WHITE
1097 RED HOT CHILI PEPPERS Asterisk Logo White
15470 CROWN THE EMPIRE Beak White T-Shirt
24330 RUDIE'S DRAWING-T WHITE
25460 OF MICE & MEN Shell White - Pocket T-Shirt
25492 THE SUMMER SET Perfectly Wasted Youth White - T-Shirt
28811 RUDIE'S (ルーディーズ) PHAT-T WHT
31527 NIRVANA IN UTERO T-Shirt
35683 NIRVANA Kurt Cobain Listen To Cobain T-Shirt
35687 NIRVANA Kurt Cobain B&W Leopard Photo T-Shirt
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
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
52908 KORN UNISEX TEE: SCRATCHED TYPE (BACK PRINT)
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53873 NIRVANA NEVERMIND T-Shirt
54602 RUDIE'S BOTANICAL PHAT-T WHITE
54647 RUDIE'S SOLID PHAT GRADATION-T WHITE
54743 FOO FIGHTERS UNISEX TEE: FLASH WINGS
55728 NIRVANA UNISEX TEE: YELLOW Happy Face
55730 OASIS UNISEX TEE: DECCA LOGO WHITE
56821 THE 1975 UNISEX TEE: ABIIOR SIDE FACE TIME (BACK PRINT)
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
58019 THRASHER TH91292 T-Shirt WHITE
58406 RUDIE'S GUESTPASS-T WHITE
58409 RUDIE'S GOOD VIBRATION BIGSILHOUETTE PKT-T WHITE
59252 NIRVANA Unisex Tee:All Apologies (Back Print)
59253 NIRVANA Unisex Tee:Xerox Happy Face Pink
60188 SLIPKNOT UNISEX T-SHIRT: IOWA GOAT SHADOW (BACK PRINT)
60261 RUDIE'S (ルーディーズ) SLICK BIGSILHOUETTE PKT-T WHITE
60347 RUDIE'S (ルーディーズ) MUSHROOM PHAT-T WHITE
61699 Subciety (サブサエティ) BOOTLEG BRAND S/S WHITE
61866 glamb (グラム) Fake Layered Border CS - White×Black
63136 RUDIE'S (ルーディーズ) DONUTS PHAT-T WHITE
63138 RUDIE'S (ルーディーズ) MICROPHONE SLICK-T WHITE
67930 BLINK-182 UNISEX RINGER T-SHIRT: ANIME
67958 LINKIN PARK UNISEX T-SHIRT: SOLDIER HYBRID THEORY WHITE
67966 NIRVANA UNISEX T-SHIRT: ANGELIC
67969 NIRVANA UNISEX T-SHIRT: TRAPPER HAT
67974 YUNGBLUD LADIES T-SHIRT: RAVER SMILE (BACK PRINT)
67975 YUNGBLUD UNISEX T-SHIRT: FACE (BACK PRINT)
68568 GREEN DAY UNISEX T-SHIRT: FLOWER POT (WASH COLLECTION)
68569 GREEN DAY UNISEX T-SHIRT: DOOKIE LONGVIEW (WASH COLLECTION)
68573 KORN UNISEX T-SHIRT: REQUIEM ALBUM COVER (BACK PRINT)
68576 LINKIN PARK UNISEX T-SHIRT: BRACKET LOGO WHITE
68582 SLIPKNOT UNISEX T-SHIRT: ADDERALL FACEBACK (BACK PRINT)
68583 SLIPKNOT UNISEX T-SHIRT: THE END (BACK PRINT)
68585 SYSTEM OF A DOWN UNISEX T-SHIRT: TRIPLE STACK BOX
68831 BRING ME THE HORIZON UNISEX T-SHIRT: BARBED WIRE (BACK PRINT)