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-18 11:06:59')
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 240, 120
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
28452 SABBAT13 ARCH LOW CAP BL
28453 SABBAT13 DARK LOW CAP BL
28454 SABBAT13 DARK LOW CAP BK
28456 SABBAT13 S-BONE LOW CAP BK
28458 SABBAT13 S-BONE LOW CAP BL
28634 SABBAT13 IGOR L/L BORDER T BK
28635 SABBAT13 IGOR L/L BORDER T WH
28636 SABBAT13 GLOOMY HUMMING L/S T BK
28638 SABBAT13 GLOOMY HUMMING L/S T WH
28647 SABBAT13 HAND MONSTER "VAMP" L/S T BK
28648 SABBAT13 HAND MONSTER "VAMP" L/S T GR
28649 SABBAT13 HAND MONSTER "VAMP" L/S T WH
28651 SABBAT13 HAND MONSTER "FRANK" L/S T BK
28652 SABBAT13 HAND MONSTER "FRANK" L/S T GR
28653 SABBAT13 HAND MONSTER "FRANK" L/S T WH
28654 SABBAT13 Message from IGOR iPhone CASE WH
28655 SABBAT13 Message from IGOR iPhone CASE BK
28812 SABBAT13 ARCH COACH JKT
28813 SABBAT13 No.13 COACH JKT
28943 SABBAT13 IGOR NEL SHIRTS GRAY
28944 SABBAT13 IGOR NEL SHIRTS GREEN
28984 SABBAT13 S-BONE SNAPBACK CAP
28987 SABBAT13 No.13 SNAPBACK CAP
28990 SABBAT13 WEIRD! SNAPBACK CAP
29692 SABBAT13 13&BONES MA-1 BLACK
29693 SABBAT13 13&BONES MA-1 OLIVE
29694 SABBAT13 13&BONES L/L SWEAT BLACK
29695 SABBAT13 GLOOMY HUMMING ZIP-PARKA BLACK
29696 SABBAT13 GLOOMY HUMMING ZIP-PARKA GREY
29697 SABBAT13 MORTAL ZIP-PARKA BLACK
29698 SABBAT13 MORTAL ZIP-PARKA GREY
29699 SABBAT13 CHILLER P/O PARKA BLACK
29700 SABBAT13 CHILLER P/O PARKA GREY
29701 SABBAT13 RUNIC P/O PARKA BLACK
29702 SABBAT13 RUNIC P/O PARKA GREY
29703 SABBAT13 GOOD DIE C/N SWEAT BLACK
29704 SABBAT13 GOOD DIE C/N SWEAT GREY
29705 SABBAT13 GOOD DIE C/N SWEAT WHITE
29706 SABBAT13 MONSTERS C/N SWEAT BLACK
29708 SABBAT13 MONSTERS C/N SWEAT WHITE
29709 SABBAT13 KNIT CAP BLACK
29710 SABBAT13 KNIT CAP BGN
29711 SABBAT13 KNIT CAP OLIVE
29712 SABBAT13 MESSAGE from IGOR L/L ZIP-PARKA
29750 SABBAT13 13&BONES SHIRTS JKT (BK)
29752 SABBAT13 HAND MONSTER "VAMP" ZIP-PARKA (BK)
29753 SABBAT13 HAND MONSTER "VAMP" ZIP-PARKA (GY)
29754 SABBAT13 HAND MONSTER "FRANK" ZIP-PARKA (BK)
29755 SABBAT13 HAND MONSTER "FRANK" ZIP-PARKA (GY)