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 10:30:45')
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 225, 75
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