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-25 04:16:20')
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
70225 NOTBADCAT (ノットバッドキャット) cats LS Tee
64934 MISHKA (ミシカ) M21100902 SHORTS
66731 NOTBADCAT (ノットバッドキャット) ニャルボロ LS Tee WHITE
66732 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee BLACK
67906 RIPNDIP (リップンディップ) Sprinkles Swim Shorts (Black)
67905 RIPNDIP (リップンディップ) Family Tree Swim Shorts (Black)
66237 glamb(グラム) Katsuki Bakugo T Black
66238 glamb(グラム) Shoto Todoroki T Black
66240 glamb(グラム) Eraser Head T Black
66733 NOTBADCAT (ノットバッドキャット) ニャルボロ LS Tee BLACK
66730 NOTBADCAT (ノットバッドキャット) ラッキーストニャイク LS Tee WHITE
66735 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee BLACK
66734 NOTBADCAT (ノットバッドキャット)ハイニャイトメンソール LS Tee WHITE
58826 MISHKA(ミシカ) M21000823 SHORTS
58134 MISHKA M21000809 Shorts
58363 KILL STAR CLOTHING Savage Mini Skirt [LEOPARD]
62525 KILL STAR Light Speed Leggings
62526 KILL STAR Kick It Leggings
62174 KILL STAR Arya Maxi Skirt
60607 RIPNDIP Ripntail Sweatshorts (Blue Mineral Wash)
60608 RIPNDIP Beverly Nylon Cargo Shorts (Blue)
54736 acOlaSia “LOT””SKULL”ハイカットスニーカー BLACK
58362 KILL STAR CLOTHING Wild Side Work Shirt
58376 WASTED PARIS Pants Knit Diaz Black
57244 mnml(ミニマル) TRACK PANTS RED
55926 MISHKA MAW200904 PANTS
55685 RIP DESIGN WORXX シークレットスマイルスキニーパンツ CRUSH
54737 acOlaSia “LOT””SKULL”ハイカットスニーカー SKULL
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
7495 OF MICE & MEN Wave Black Tank Top
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
11441 MAYDAY PARADE Keyhole Black / White
13093 RIP DESIGN WORXX SPIDER TIE DYE Tee WHITE
13095 RIP DESIGN WORXX SPIDER TIE DYE Tee RED
13096 RIP DESIGN WORXX SPIDER TIE DYE Tee BLUE