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 dtb_products AS p
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-14 13:17:49')
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 13,35,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 60
22681 ライブキッズあるある ライブ行きたいTシャツ
21977 セプテンバーミー YES! YES! YES! Tシャツ 黒
22718 ザ・チャレンジ カラフルBOXロゴ Tシャツ BLK
23454 HER NAME IN BLOOD BEAST MODE TOUR T-Shirts
24261 UNDEAD CORPORATION LOGO Tshirt BLK×RED
28367 ALL OFF おふくろ国旗Tシャツ Black
13900 NEW BREED The DIVIDE TEE
21141 BEFORE MY LIFE FAILS NEW LOGO TEE BLACK
31952 Bentham ExPツアーTシャツ BLACK
20126 激ロック×サボパン【激サボパンTシャツ】 BLACK
42595 Bentham Chicago Tシャツ ブラック
36971 フクザワ 【まったり】 Tシャツ
21086 ヒステリックパニック 「オトナとオモチャでアソボウゼー!!TOUR 2015」ツアーT BLK
43175 【甘夏ゆず×つぶら】つぶぽん T-Shirt BLACK
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
9424 WHITECHAPEL Riot Black T-Shirt
11451 TEXAS IN JULY Without A Head! Black
12067 PANTERA HOSTILE SKULL T-Shirt
21124 ATTILA Dirty Black
24662 ISSUES I Have Issues Black - T-Shirt
24757 WHITECHAPEL Sawblade Grey on Navy - T-Shirt
24758 WHITECHAPEL Sawblade Camo on Black - T-Shirt
25127 THE STORY SO FAR Snakes Black - T-Shirt
25227 MISS FORTUNE Leader Black - T-Shirt
25257 CAPTURE THE CROWN We Are All Royalty Black - T-Shirt
25302 BEFORE THEIR EYES Cross Black - T-Shirt
26455 SLEEPING WITH SIRENS Red Chain
27374 THE USED VULNERABLE T
27794 LANDON TEWERS The Captain Black
28295 THE BROWNING Skull Black
28310 FRONZILLA Party People's Anthem Black TankTop
28641 AMON AMARTH WOLFORD
31531 OF MICE AND MEN FLIP HAT DEMON TEE
55718 ASKING ALEXANDRIA UNISEX TEE: SKULL SHIELD (RETAIL PACK)
55722 CROWN THE EMPIRE UNISEX TEE: SACRIFICE (RETAIL PACK)
20216 【激ロック限定デザイン】NINJA KORE THE NINJA
20217 【激ロック限定デザイン】NINJA KORE MR.BOMB
52942 Survive Said The Prophet MIA TOUR TEE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
7432 WOE IS ME Griffin Black
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9428 THE WORD ALIVE Bullets Black T-Shirt
11283 CAPTURE THE CROWN Gargoyle Black
15342 WHITECHAPEL Doom Black
15383 WITHIN THE RUINS Red Crest Black Tank Top
15427 THE WORD ALIVE Lighthouse Black
15435 PIERCE THE VEIL Logo Black
15437 THE WORD ALIVE Poseiden Black
15496 ALL THAT REMAINS A War You Cannot Win Black
15509 WE CAME AS ROMANS Reasons Black
19001 WHITECHAPEL Pocket Blade Black
19805 CAPTURE THE CROWN Coat Of Arms Black
19810 CAPTURE THE CROWN Leopard
25491 THE SUMMER SET Legendary Black - T-Shirt
36784 DISTURBEDMusic As A Weapon 06-07 Tour T-shirt
36825 DEFTONES California Rider-Black t-shirt
37034 PANTERA Band Flames T-Shirt
70716 Survive Said The Prophet OMEN TEE