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-03-29 23:25:13')
AND FIND_IN_SET(3, p.color)
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 0, 75
69531 SABBAT13(サバトサーティーン) BURGLER SWEAT ASH
69533 SABBAT13(サバトサーティーン) DEATH HAWK L/S T WHITE
69536 SABBAT13(サバトサーティーン) BORED BIG L/S T WHITE
68439 SABBAT13(サバトサーティーン) SCAPEGOAT T (WHITE)
65607 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (BK/WH)
65603 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S RAGLAN T" (NV/WH)
65605 RUDIE'S(ルーディーズ)×SABBAT13(サバトサーティーン) ”RUD13'S T" (WH)
64504 SABBAT13(サバトサーティーン) FRIEND T (WH)
64502 SABBAT13(サバトサーティーン) GOD T (WH)
65012 SABBAT13(サバトサーティーン) SPOOK BIG POCKET T (WH)
63258 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt WHITE
60612 SABBAT13 CONSPIRACY L/S T WHITE
58552 SABBAT13 AMBITION T ホワイト
58564 SABBAT13 GLUTTONY T ホワイト
58554 SABBAT13 MALUS T ホワイト
57136 SABBAT13 SPOOK INSIDE T WHITE
57142 SABBAT13 HIDE&SEEK T WHITE
57145 SABBAT13 GHOSTLY T WHITE
57150 SABBAT13 CREEPY BIG T WHITE
57127 SABBAT13 SPOOK INSIDE L/S T WHITE
57133 SABBAT13 HIDE&SEEK L/S T WHITE
55608 SABBAT13 GHOSTLY HOODIE ホワイト
55586 SABBAT13 GHOST SOX ホワイト
55599 SABBAT13 GHOSTLY L/S T ホワイト
19088 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6plus WHITE
21677 SABBAT13 GOOD DIE L/S T-sh WHT
21682 SABBAT13 GOOD DIE 7/S RAGLAN T WHT
21684 SABBAT13 EERIE AD. 7/S RAGLAN T WHT
21686 SABBAT13 WALK DEADLY 7/S RAGLAN T WHT
21865 SABBAT13 No.13 L/S T-sh WHT
22513 SABBAT13 MORTAL PARKA (WH)
22516 SABBAT13 CROWN BIG SWEAT (WH)
23905 SABBAT13 13X PANEL BIG T-sh (WH/BK)
23906 SABBAT13 13X PANEL BIG T-sh (BK/WH)
24368 SABBAT13 BEYOND THE GRAVE 7/S RAGLAN T WHTE
24373 SABBAT13 BEYOND THE GRAVE T-shirt White
24805 SABBAT13 IGOR BORDER T WHT
24810 SABBAT13 HAND MONSTERS "FRANKEN" T-sh WHT
25217 SABBAT13 GRUNGE RAYERD LONG T WH
27823 SABBAT13 MONSTERS T-sh (WH)
28635 SABBAT13 IGOR L/L BORDER T WH
28638 SABBAT13 GLOOMY HUMMING L/S T WH
28649 SABBAT13 HAND MONSTER "VAMP" L/S T WH
28653 SABBAT13 HAND MONSTER "FRANK" L/S T WH
28654 SABBAT13 Message from IGOR iPhone CASE WH
29705 SABBAT13 GOOD DIE C/N SWEAT WHITE
29708 SABBAT13 MONSTERS C/N SWEAT WHITE
32283 SABBAT13 IGOR L/L HOOD NEL SHIRTS (WH)
32444 SABBAT13 SKATE "THING" L/S T WHITE
32446 SABBAT13 LIFE L/S T WHITE
32448 SABBAT13 DYING 2WAY TOTE BAG NATURAL
34004 SABBAT13 13X-BONE T (WH)
34209 SABBAT13 MORTAL OX S/S SHIRTS (WH)
34211 SABBAT13 DYING "OFFICER" T (WH)
34216 SABBAT13 DYING "BURGLAR" T (WH)
34220 SABBAT13 FEEL WEIRD BIG T (WH)
34228 SABBAT1313X-BONE 7/S RAGLAN T (WH)
34230 SABBAT13 S-BONE 7/S RAGLAN T (WH)
34377 SABBAT13 WEIRD THINGS S/S SHIRTS (WH)
34957 SABBAT13 GLORY BORDER L/S T (ホワイト) WHITE
34959 SABBAT13 CAMO POCKET L/S T WHITE
34967 SABBAT13 JANKEN HOODIE (ホワイト) WHITE
34970 SABBAT13 GASP HOODIE (ホワイト) WHITE
34971 SABBAT13 GASP HOODIE (グレー) GRAY
34973 SABBAT13 SKATE ""THING"" HOODIE(ホワイト) WHITE
34975 SABBAT13 MORTAL SWEAT (ホワイト) WHITE
34981 SABBAT13 JANKEN L/S T (ホワイト) WHITE
34997 SABBAT13 BEAST iPhone CASE (ホワイト) WHITE
36546 CSABBAT13 RYPT LOGO TEE WHITE
36548 SABBAT13 HALF DEATH TEE WHITE
36550 SABBAT13 BEAST TEE WHITE
36552 SABBAT13 666 BIG TEE WHITE
39518 SABBAT13 HAND OF GLORY L/S T (WH)
39783 SABBAT13 CALL OF THE DEAD L/S T (WH)
39962 SABBAT13 WEIRD LOW CAP(WH)