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 17:29:59')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(10, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
18061 【ゲキクロ限定カラー】 四星球 ドット絵Tシャツ YELLOW
54452 MISHKA(ミシカ) MSS200031 T-SHIRTS Safety Green
54728 SANTA CRUZ SCREAMING HAND S/S TEE GOLD
63125 HEDWiNG (ヘドウィグ) Fall down Neon T-shirt Banana yellow
58781 TOY MACHINE (トイマシーン) DESIGN PRINT TEE LEMON
22724 コレサワ れ子ちゃんブイーンしてるやつTシャツ(調子のいい黄色)
28730 彼女 IN THE DISPLAY THE ROOTS Tシャツ WHT
34157 Xmas Eileen Photo Tシャツ YELLOW
62667 PUNK DRUNKERS[PDSxホープ軒]元祖背脂TEE - YELLOW
64871 HYPER CORE(ハイパーコア) TROPICAL BEAR Tシャツ YELLOW
64186 over print(オーバープリント) back pennant Tee (light yellow)
64997 over print(オーバープリント) Velbed emblem Tee (light yellow)
22852 四星球 モンスターTシャツ(黄)
42629 KEYTALK シンプルロゴ刺繍Tシャツ バナナ
64146 SABBAT13(サバトサーティーン) FRIEND T (GD)
25134 SEAWAY Colour Blind TV Logo Yellow - T-Shirt
25194 IWRESTLEDABEARONCE Pizza Yellow - T-Shirt
36104 NIRVANA Cartoon Sitting Photo-Gold t-shirt
63733 over print (オーバープリント) EMB logo Tee 1 (light yellow)
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
58324 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT YELLOW
35667 BRING ME THE HORIZON KK YELLOW T-SHIRTS
35702 RED HOT CHILI PEPPERS RHCP Brazil Colors t-shirt Yellow
54649 mnml(ミニマル) STRIOED BOXY TEE BLUE/YELLOW
55678 RIP DESIGN WORXX ディスグースマスクTシャツ YELLOW
45949 BRING ME THE HORIZON HEXAGRAM AMO SMALL YELLOW
54699 MISHKA(ミシカ) MSS200030 T-SHIRTS ORANGE/PURPLE
59134 PUNK DRUNKERS 鮫人パジャマTEE - D.YELLOW
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
53051 SABBAT13 PENNYWISE T YELLOW
55309 NieR (ニーア) BIG SIZE YELLOW OFF-SHOULDER TOPS【リボン付き】
57146 SABBAT13 GHOSTLY T GOLD
68242 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE L. YELLOW
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
54127 ROLLING CRADLE TIEFYE TEE YELLOW
54291 PUNK DRUNKERS タイダイーズTEE - GREEN
63260 沢城千春×SABBAT13×GEKIROCK CLOTHING Stand T-Shirt ORANGE
63718 over print (オーバープリント) planet Tee (yellow orange)
68314 over print (オーバープリント) Distortion Tee (yellow)
58131 MISHKA M21000007 T-Shirt Yellow
63098 MISHKA (ミシカ) M21100009 T-SHIRT YELLOW
54459 MISHKA(ミシカ) MSS200044 T-SHIRTS
58133 MISHKA M21000066 T-Shirt Yellow
61784 MISHKA (ミシカ) M21100032 T-SHIRT L.GREEN
65336 Subciety (サブサエティ) LIBIDOS TEE YELLOW
67812 over print(オーバープリント) CARD Tee yellow
71271 SCENE TOKYO (シーントウキョウ) ice girl Tee (banana)
71352 over print (オーバープリント) GHOST BUSTERS Tee 10 yellow
57362 MISHKA M21000059 T-Shirt YELLOW
58824 MISHKA(ミシカ) M21000021 T-SHIRTS
59357 TRAVAS TOKYO【トラヴァストーキョー】グラフィック総柄スーパービッグTシャツ White
59358 TRAVAS TOKYO【トラヴァストーキョー】グラフィック総柄スーパービッグTシャツ Black
62294 Zephyren(ゼファレン) S/S TEE - In vino veritas - YELLOW
58204 PUNK DRUNKERS タイダイマッポTEE - GREEN/YELLOW
71343 over print (オーバープリント) GHOST BUSTERS Tee 6 yellow
53139 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type A
53140 HEDWiNG HD1-016 Crosscut Missing “Sectum” T-shirt YEL×GRN type B
70754 攻殻機動隊 STAND ALONE COMPLEX x Subciety incident TEE YELLOW
56040 SAMURAI CORE SR-TE-014D 東京水玉禁止令 TEE YELLOW
68401 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE YELLOW