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 19:44:41')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
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
LIMIT 0, 120
13196 SABBAT13 Shrunken Head T-shirt PP
17393 SABBAT13 BONE LADY 13X T-sh GY
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
18018 SABBAT13 13&BONES FOOTBALL T GRY
18021 SABBAT13 WEIRD T-sh BLK
18022 SABBAT13 WEIRD T-sh NVY
18264 SABBAT13 WEIRD CAMO POCKET T BLK
18265 SABBAT13 WEIRD CAMO POCKET T WHT
18266 SABBAT13 WEIRD CAMO POCKET T GRY
18267 SABBAT13 WEIRD SWEAT T BLK
18269 SABBAT13 WEIRD SWEAT T NVY
18272 SABBAT13 CHEERS T-sh GRY
18288 SABBAT13 WEIRD SWEAT T GRY
19143 SABBAT13 IGOR BICOLOR T
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 (ラベンダー)
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
54113 SABBAT13 BLESSING T BLACK
54114 SABBAT13 BLESSING T TURQUOISE
54503 【バンドリ!×ゲキクロ第1弾復刻】SABBAT13×宇田川あこコラボ 限定 Tシャツ
57135 SABBAT13 SPOOK INSIDE T BLACK
57136 SABBAT13 SPOOK INSIDE T WHITE
57137 SABBAT13 SPOOK INSIDE T TURQUOISE
57142 SABBAT13 HIDE&SEEK T WHITE
57143 SABBAT13 HIDE&SEEK T MINT
57144 SABBAT13 GHOSTLY T BLACK
57145 SABBAT13 GHOSTLY T WHITE
57146 SABBAT13 GHOSTLY T GOLD
57149 SABBAT13 CREEPY BIG T BLACK
57150 SABBAT13 CREEPY BIG T WHITE
57151 SABBAT13 CREEPY BIG T BEIGE
58548 SABBAT13 GHOST POCKET T ブラック
58549 【予約商品】SABBAT13 GHOST POCKET T キャメル
58561 SABBAT13 LOST PARADISE T ブラック
58563 SABBAT13 GLUTTONY T ブラック
58556 SABBAT13 SUPPER T ブラック
58551 SABBAT13 AMBITION T ブラック
58555 SABBAT13 MALUS T コーラルベージュ
58554 SABBAT13 MALUS T ホワイト
58564 SABBAT13 GLUTTONY T ホワイト
58558 SABBAT13 SUPPER T オリーブ
58559 SABBAT13 WIND PRANK T ブラック
58552 SABBAT13 AMBITION T ホワイト
58557 SABBAT13 SUPPER T ベージュ