SELECT SQL_CALC_FOUND_ROWS 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-04-26 02:38:46')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 436)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 25
13160 BLACK HOLE BUNNY Tシャツ Galaxy Logo BLACK
13161 BLACK HOLE BUNNY Tシャツ Galaxy Logo WHITE
13162 BLACK HOLE BUNNY Tシャツ Galaxy Logo PINK
13163 BLACK HOLE BUNNY Tシャツ Galaxy Logo BLUE
13164 BLACK HOLE BUNNY Tシャツ Galaxy Logo PURPLE
13168 BLACK HOLE BUNNY Tシャツ ▼ WHITE
13169 BLACK HOLE BUNNY Tシャツ ▽ BLACK
13170 BLACK HOLE BUNNY Tシャツ ▽ WHITE
20132 BLACK HOLE BUNNY Tシャツ slip
20134 BLACK HOLE BUNNY Gummy Delta WHITE
20136 BLACK HOLE BUNNY Camouflage Delta WHITE
20201 BLACK HOLE BUNNY 缶バッジ guiltless
20202 BLACK HOLE BUNNY 缶バッジ 首締めウサギ
20203 BLACK HOLE BUNNY 缶バッジ ▽ WHT
20204 BLACK HOLE BUNNY 缶バッジ ▽ BLK
20205 BLACK HOLE BUNNY 缶バッジ ▼ BLK
20206 BLACK HOLE BUNNY 缶バッジ ▼ WHT
20207 BLACK HOLE BUNNY 缶バッジ BAD RABBIT DIE ON THE CROSS
20208 BLACK HOLE BUNNY 缶バッジ ゾンビくん
20209 BLACK HOLE BUNNY 缶バッジ 縛られウサギ
20210 BLACK HOLE BUNNY 缶バッジ bite
20211 BLACK HOLE BUNNY ラグランTシャツ 首締めウサギ
20212 BLACK HOLE BUNNY BAD RABBIT DIE ON THE CROSS
22117 BLACK HOLE BUNNY ラグラン Hanging Rabbit YEL/WHT/BLU
22118 BLACK HOLE BUNNY ラグラン Hanging Rabbit YEL/WHT/BLK