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 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-28 22: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 p.update_date
LIMIT 0, 75
29707 SABBAT13 MONSTERS C/N SWEAT GREY
34962 SABBAT13 S-BONE ZIP HOODIE (グレー) GRAY
39515 SABBAT13 HAND OF GLORY ZIP HOODIE (NAVY)
52438 SABBAT13 PARADISE HOODIE(ブラック)
34943 SABBAT13 REAPER SWING TOP JKT (ブラック) BLACK
39512 SABBAT13 PATCH MILITARY BIG JKT (BK)
13196 SABBAT13 Shrunken Head T-shirt PP
13205 SABBAT13 13X DOT SHORTS BE
13208 SABBAT13 PVC KEY HOLDER IGOR
13644 SABBAT13×激ロック TOTE BAG
13645 SABBAT13×激ロック 缶バッジ BLACK
13646 SABBAT13×激ロック 缶バッジ WHITE
13647 SABBAT13×激ロック 缶バッジ BLUE
13649 SABBAT13×激ロック 缶バッジ RED
13650 SABBAT13×激ロック TOTE BAG & 缶バッジ4色セット
13651 SABBAT13×激ロック 缶バッジ 4色セット
14732 SABBAT13 WICCA CHAMBLAY L/S SHIRTS (GY)
14736 SABBAT13 CRYPT ZIP-PARKA (BK)
14737 SABBAT13 CRYPT ZIP-PARKA (GY)
14740 SABBAT13 REBEL L/S T (GY)
15870 SABBAT13 KNIT CAP BURGUNDY
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
18015 SABBAT13 REAPER COACH JKT
18018 SABBAT13 13&BONES FOOTBALL T GRY
18019 SABBAT13 RUNIC LIGHT CARDIGAN BLK
18020 SABBAT13 RUNIC LIGHT CARDIGAN 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
18276 SABBAT13 CROSS LOGO SNAPBACK CAP BLK
18278 SABBAT13 CROSS LOGO SNAPBACK CAP GRY
18279 SABBAT13 CROSS LOGO BUCKET HAT BLK
18281 SABBAT13 CROSS LOGO BUCKET HAT WHT
18288 SABBAT13 WEIRD SWEAT T GRY
19088 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6plus WHITE
19089 SABBAT13 BONE LADY 13X iPhone SKIN+JKT 6+ BLACK
19090 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ BLACK
19091 SABBAT13 BONE CAMO iPhone SKIN+JKT 6+ GREEN
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
21672 SABBAT13 SCARE PULL-OVER PARKA BLK
21673 SABBAT13 SCARE PULL-OVER PARKA GRY
21674 SABBAT13 SCARE PULL-OVER PARKA WHT
21675 SABBAT13 GOOD DIE L/S T-sh BLK
21676 SABBAT13 GOOD DIE L/S T-sh GRY
21677 SABBAT13 GOOD DIE L/S T-sh WHT
21678 SABBAT13 No.13 L/S T-sh BLK
21679 SABBAT13 No.13 L/S T-sh GRY
21682 SABBAT13 GOOD DIE 7/S RAGLAN T WHT
21683 SABBAT13 GOOD DIE 7/S RAGLAN T GRY
21684 SABBAT13 EERIE AD. 7/S RAGLAN T WHT
21685 SABBAT13 EERIE AD. 7/S RAGLAN T GRY
21686 SABBAT13 WALK DEADLY 7/S RAGLAN T WHT
21689 SABBAT13 WALK DEADLY 7/S RAGLAN T GRY
21865 SABBAT13 No.13 L/S T-sh WHT
22172 SABBAT13 CABLE KNIT CAP BLACK
22173 SABBAT13 CABLE KNIT BURGUNDY
22174 SABBAT13 CABLE KNIT BLUE