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-24 00:52:17')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND FIND_IN_SET(16, p.color)
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 7
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
70280 BULLET FOR MY VALENTINE UNISEX T-SHIRT: RAM (BACK PRINT)
68206 バンドじゃないもん!MAXX NAKAYOSHI×GEKIROCK CLOTHING×KAVANE Clothingコラボ・ドッグタグ
65305 三宅 葵依×アマツカミ コラボ 限定 ドッグタグ
35640 PANTERA Logo Key Chain
25225 POLYPHIA Clouds Black - Pullover
26276 DESCENDENTS EVERYTHING SUCKS LAPEL PIN
31939 KEYTALK 缶バッジセット 銀
34435 AA= #5 BADGE(54mm)-SILVER-
35559 BRING ME THE HORIZON This is Sempiternal KEY CHAIN
35639 PANTERA Cowboys from Hell Key Chain
36672 IRON MAIDEN IRON MAIDEN LOGO WITH NO TAILS Keychain
42598 KEYTALK プラスチックグラス
51192 SLIPKNOT STANDARD KEYCHAIN: LOGO
52515 MARILYN MANSON WRIST STRAP LOGO
52904 MARILYN MANSON PENDANT: T CROSS NECKLACE