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-04-24 10:46:11')
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
LIMIT 0, 120
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
22193 SABBAT13 13 and BONES STADIUM JACKET
22194 SABBAT13 IGOR NEL SHIRTS RED
22195 SABBAT13 IGOR NEL SHIRTS GREEN
22196 SABBAT13 CROWN LONG NEL SHIRTS RED
22197 SABBAT13 CROWN LONG NEL SHIRTS BLUE
22198 SABBAT13 IGOR BICOLOR L/S T WHT
22199 SABBAT13 IGOR BICOLOR L/S T GRY
22344 SABBAT13 ARCH SNAPBACK CAP BLK
22345 SABBAT13 ARCH SNAPBACK CAP GRY
22346 SABBAT13 MORTAL SNAPBACK CAP BLK
22347 SABBAT13 MORTAL SNAPBACK CAP GRY
22348 SABBAT13 CROWN SNAPBACK CAP BLK
22349 SABBAT13 CROWN SNAPBACK CAP GRY
22509 SABBAT13 ARCH ZIP-PARKA (GY)
22510 SABBAT13 ARCH ZIP-PARKA (BK)
22511 SABBAT13 MORTAL PARKA (BK)
22512 SABBAT13 MORTAL PARKA (GY)
22513 SABBAT13 MORTAL PARKA (WH)
22514 SABBAT13 CROWN BIG SWEAT (BK)
22515 SABBAT13 CROWN BIG SWEAT (GY)
22516 SABBAT13 CROWN BIG SWEAT (WH)
22659 SABBAT13 DISPORT BACK PACK BE
22660 SABBAT13 DISPORT BACK PACK BK
23743 SABBAT13 IGOR C/N SWEAT CARDIGAN (BLACK)
23744 SABBAT13 IGOR C/N SWEAT CARDIGAN (OLIVE)
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
24368 SABBAT13 BEYOND THE GRAVE 7/S RAGLAN T WHTE
24369 SABBAT13 BEYOND THE GRAVE 7/S RAGLAN T GRAY
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
25219 SABBAT13 iPhone6/6s・6plusCASE EERIE AD
25220 SABBAT13 iPhone6/6s CASE 13X DOT
27821 SABBAT13 RESURGENT T-sh (RD)
27822 SABBAT13 RESURGENT T-sh (YE)
27823 SABBAT13 MONSTERS T-sh (WH)
27824 SABBAT13 MONSTERS T-sh (BK)
27825 SABBAT13 13&BONES SNAPBACK CAP
27826 SABBAT13 WIDE BRIM BUCKET HAT
28451 SABBAT13 ARCH LOW CAP BK