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-24 20:06:21')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.classcategory_id1 IN( 15,19,61)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
66237 glamb(グラム) Katsuki Bakugo T Black
66238 glamb(グラム) Shoto Todoroki T Black
66240 glamb(グラム) Eraser Head T Black
919 The Devil Wears Prada Virus Allover Print T-Shirt
4349 ENTER SHIKARI Destabilize Tour Black
6021 OF MICE & MEN Faithfulness Black T-Shirt
6147 THE WORD ALIVE Minotaur Black
7432 WOE IS ME Griffin Black
7445 MAYDAY PARADE All I Do Black
7506 MAYDAY PARADE Meowday Purrrade Black
9173 MOTIONLESS IN WHITE America Black T-Shirt
9174 MOTIONLESS IN WHITE Middle Finger Black
11229 Nine Microphones HEAVEN S/S Gray
11232 ENTER SHIKARI Fear Not Navy
11236 WOE IS ME Circus Revenge Black
11242 ENTER SHIKARI Police Natural
11246 BREATHE CAROLINA Mammoth Black
11251 MOTIONLESS IN WHITE Mask Black
11256 MAYDAY PARADE Photo Collage Black
11257 A SKYLIT DRIVE Gorilla Vs. Raptor Black
11284 ENTER SHIKARI Stealth Black
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
11301 ENTER SHIKARI Texas Silver
11302 MAYDAY PARADE Lightning Mic Black T-Shirt
11305 ENTER SHIKARI Band Charcoal
11308 MOTIONLESS IN WHITE Grim Reaper Black
11310 MOTIONLESS IN WHITE Puppet Black
11424 OF MICE & MEN Restoring Force Album Heather GRY
11440 TEXAS IN JULY Bed Of Nails Black
15365 TONIGHT ALIVE Indian Pattern White T-Shirt
15373 NEW FOUND GLORY Juggernaut Black T-Shirt
15374 NEW FOUND GLORY Prophet Black T-Shirt
15376 THE USED Heart White T-Shirt
15408 MEMPHIS MAY FIRE Red Logo Black
15411 MEMPHIS MAY FIRE Shield Prove Me Right White
15436 PIERCE THE VEIL Seal Black T-Shirt
15437 THE WORD ALIVE Poseiden Black
15454 MOTIONLESS IN WHITE Reincarnate Coffin Black TEE
15456 MOTIONLESS IN WHITE Icon Black On Charcoal Heather
15457 MOTIONLESS IN WHITE Full Band Photo Black
15459 MOTIONLESS IN WHITE Logo Black TEE
15464 MOTIONLESS IN WHITE Raven Black TEE
15466 CHIODOS Chaos White T-Shirt
15467 CHIODOS This Is Love Band - T-Shirt
15510 WE CAME AS ROMANS Hope Crest Black
15514 WE CAME AS ROMANS Wolf Black
15532 MAYDAY PARADE Photo Black
15535 MAYDAY PARADE Broken Heart Black
15571 OF MICE & MEN Faithfulness Heather Grey
16680 【ゲキクロ限定カラー】lynch. ツアーTシャツ RED
17477 DROP DEAD CLOTHING Chubracbra T-Shirt(B)
17797 Hi-STANDARD Live at TOHOKU AIR JAM 2012 TEE YELLOW
19801 CHUNK!NO,CAPTAIN CHUNK! Gray Text
19835 THE SUMMER SET Floral Triangle Teal
19877 Iwrestledabearonce Hello Black
20553 PALISADES Wolves...TS Black
21114 ISSUES Diamond Eyes Black
21115 ISSUES Too Many Moons Heather Tank Top
21116 ISSUES Many Moons Ago Heather Athletic Gray T-Shir