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-04-27 23:15:23')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 437)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 75, 75
19144 SABBAT13 IGOR BORDER-POCKET T BLK
19145 SABBAT13 IGOR BORDER-POCKET T WHT
19146 SABBAT13 LIVEVIL PANEL T BLK
19147 SABBAT13 LIVEVIL PANEL T WHT
19148 SABBAT13 REAPER POCKET T-sh BLK
19149 SABBAT13 REAPER POCKET T-sh GRY
19150 SABBAT13 REAPER POCKET T-sh WHT
23905 SABBAT13 13X PANEL BIG T-sh (WH/BK)
23906 SABBAT13 13X PANEL BIG T-sh (BK/WH)
24365 SABBAT13 13X 5/S FOOTBALL T-shirt WHITE
24366 SABBAT13 13X 5/S FOOTBALL T-shirt BLACK
24371 SABBAT13 BEYOND THE GRAVE T-shirt Gray
24372 SABBAT13 BEYOND THE GRAVE T-shirt Black
24373 SABBAT13 BEYOND THE GRAVE T-shirt White
24805 SABBAT13 IGOR BORDER T WHT
24806 SABBAT13 IGOR BORDER T GRY
24807 SABBAT13 HAND MONSTERS "VAMPIRE" T-sh BLK
24808 SABBAT13 HAND MONSTERS "VAMPIRE" T-sh WHT
24809 SABBAT13 HAND MONSTERS "FRANKEN" T-sh BLK
24810 SABBAT13 HAND MONSTERS "FRANKEN" T-sh WHT
25217 SABBAT13 GRUNGE RAYERD LONG T WH
25218 SABBAT13 GRUNGE RAYERD LONG T BK
27821 SABBAT13 RESURGENT T-sh (RD)
27822 SABBAT13 RESURGENT T-sh (YE)
27823 SABBAT13 MONSTERS T-sh (WH)
27824 SABBAT13 MONSTERS T-sh (BK)
34004 SABBAT13 13X-BONE T (WH)
34005 SABBAT13 13X-BONE T (BK)
34210 SABBAT13 DYING "OFFICER" T (BK)
34211 SABBAT13 DYING "OFFICER" T (WH)
34215 SABBAT13 DYING "BURGLAR" T (BK)
34216 SABBAT13 DYING "BURGLAR" T (WH)
34218 SABBAT13 FEEL WEIRD BIG T (BK)
34220 SABBAT13 FEEL WEIRD BIG T (WH)
34222 SABBAT13 FEEL WEIRD BIG T (GY)
36546 CSABBAT13 RYPT LOGO TEE WHITE
36548 SABBAT13 HALF DEATH TEE WHITE
36549 SABBAT13 HALF DEATH TEE BLACK
36550 SABBAT13 BEAST TEE WHITE
36551 SABBAT13 BEAST TEE BLACK
36552 SABBAT13 666 BIG TEE WHITE
36553 SABBAT13 666 BIG TEE BLACK
40574 SABBAT13 WALK DEADLY BIG T (BK)
40575 SABBAT13 WALK DEADLY BIG T (WH)
40578 SABBAT13 SLEEP WALKER T (BK)
40579 SABBAT13 SLEEP WALKER T (WH)
40580 SABBAT13 SCAPEGOAT T(BK)
40581 SABBAT13 SCAPEGOAT T (WH)
48375 SABBAT13 Voo Doo Doll T (ブラック)
48376 SABBAT13 Voo Doo Doll T (ホワイト)
48377 SABBAT13 Voo Doo Doll T (SAX)
48378 SABBAT13 BLACK MAGIC T (ブラック)
48380 SABBAT13 BLACK MAGIC T (ラベンダー)
49077 SABBAT13 WICKED BORDER S/S T (ホワイト)
49078 SABBAT13 WICKED BORDER S/S T (レッド)
49080 SABBAT13 SHABBY S/S T(イエロー)
49081 SABBAT13 SHABBY S/S T(パープル)
49082 SABBAT13 PATCHWORK S/S T(ブラック)
49083 SABBAT13 PATCHWORK S/S T(ホワイト)
49084 SABBAT13 PATCHWORK S/S T(イエロー)
50640 SABBAT13 SKATE HAND L/S T(ホワイト)
53029 SABBAT13 HODGE PODGE T BLACK
53030 SABBAT13 HODGE PODGE T PURPLE
53031 SABBAT13 FRIEND T BLACK
53032 SABBAT13 FRIEND T PURPLE
53033 SABBAT13 FRIEND T WHITE
53040 SABBAT13 PARADISE T BLACK
53041 SABBAT13 PARADISE T BURGANDY
53042 SABBAT13 CASKET T BLACK
53044 SABBAT13 SKATE HAND T BLACK
53051 SABBAT13 PENNYWISE T YELLOW
53052 SABBAT13 PENNYWISE T BLACK
53053 SABBAT13 PENNYWISE T WHITE
54111 SABBAT13 SKATE HAND T WHITE
54112 SABBAT13 CASKET T LAVENDER