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-28 02:04:41')
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 MAX(price02)
LIMIT 0, 75
58549 【予約商品】SABBAT13 GHOST POCKET T キャメル
53029 SABBAT13 HODGE PODGE T BLACK
64145 SABBAT13(サバトサーティーン) GOD T (PK)
64148 SABBAT13(サバトサーティーン) STORY TELLING T (BG)
64149 SABBAT13(サバトサーティーン) STORY TELLING T (KH)
65014 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BG)
65021 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (GR)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
57141 SABBAT13 HIDE&SEEK T BLACK
57142 SABBAT13 HIDE&SEEK T WHITE
57151 SABBAT13 CREEPY BIG T BEIGE
58555 SABBAT13 MALUS T コーラルベージュ
58557 SABBAT13 SUPPER T ベージュ
58559 SABBAT13 WIND PRANK T ブラック
65020 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (SMOKE)
64146 SABBAT13(サバトサーティーン) FRIEND T (GD)
65011 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (BK)
65012 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (WH)
57136 SABBAT13 SPOOK INSIDE T WHITE
13196 SABBAT13 Shrunken Head T-shirt PP
17399 SABBAT13 TITLE T-sh BK
17400 SABBAT13 TITLE T-sh GY
17404 SABBAT13 KEEP WEIRD T-sh BK
17407 SABBAT13 DEADLY T-sh BK
17408 SABBAT13 DEADLY T-sh GY
17411 SABBAT13 REBEL T-sh GR
18021 SABBAT13 WEIRD T-sh BLK
18022 SABBAT13 WEIRD T-sh NVY
18272 SABBAT13 CHEERS T-sh GRY
24805 SABBAT13 IGOR BORDER T WHT
24806 SABBAT13 IGOR BORDER T GRY
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)
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
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
34218 SABBAT13 FEEL WEIRD BIG T (BK)
34220 SABBAT13 FEEL WEIRD BIG T (WH)
34222 SABBAT13 FEEL WEIRD BIG T (GY)
36552 SABBAT13 666 BIG TEE WHITE
36553 SABBAT13 666 BIG TEE BLACK
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 (ラベンダー)
64147 SABBAT13(サバトサーティーン) STORY TELLING T (BK)
64502 SABBAT13(サバトサーティーン) GOD T (WH)
64503 SABBAT13(サバトサーティーン) GOD T (BK)
64504 SABBAT13(サバトサーティーン) FRIEND T (WH)
64505 SABBAT13(サバトサーティーン) FRIEND T (BK)
65023 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (BG)
65604 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (BK)
65606 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (GR)
18264 SABBAT13 WEIRD CAMO POCKET T BLK
18265 SABBAT13 WEIRD CAMO POCKET T WHT
18266 SABBAT13 WEIRD CAMO POCKET T GRY