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-27 00:18:13')
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 85)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 960, 120
39382 ROLLING CRADLE RC STANDARD TWILL SHORTS BURGUNDY
39383 ROLLING CRADLE RC STANDARD TWILL SHORTS BLACK
39386 ROLLING CRADLE RC×B&B HOODIE "TV FREAK" BLACK
39387 ROLLING CRADLE RC×B&B HOODIE "TV FREAK" GRAY
39388 ROLLING CRADLE RC×B&B HOODIE "BEAVIS CORNHOLIO" BLACK
39389 ROLLING CRADLE RC×B&B HOODIE "BEAVIS CORNHOLIO" GRAY
39390 ROLLING CRADLE RC×B&B LONG Tee "TITTY TWISTER" BLACK
39391 ROLLING CRADLE RC×B&B LONG Tee "TITTY TWISTER" WHITE
39394 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" WHITE
39395 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" BLACK
39396 ROLLING CRADLE RC×B&B Tee "TITTY TWISTER" LIGHT BLUE
39406 ROLLING CRADLE S. N COACH JKT STRONG STYLE HAS ARRIVED
39407 ROLLING CRADLE S. N Tee "TOP OF GLORY"
39408 ROLLING CRADLE S. N Tee "STRONG STYLE HAS ARRIVED" BLACK
39409 ROLLING CRADLE AJ COAH JKT "THE PHENOMENAL ONE" BLACK
39410 ROLLING CRADLE RC REVERSIBLE BELL HAT BLACK
39411 ROLLING CRADLE RC REVERSIBLE BELL HAT RED
39413 ROLLING CRADLE RC CYCLOPS TERROR CAP BLACK
39414 ROLLING CRADLE RC CYCLOPS TERROR CAP NAVY
39415 ROLLING CRADLE SUPER ROLLING CRADLE CAP BLACK
39416 ROLLING CRADLE SUPER ROLLING CRADLE CAP WHITE
39417 ROLLING CRADLE RC CHEMICAL TOTE BAG GREEN
39418 ROLLING CRADLE RC CHEMICAL TOTE BAG RED
39419 ROLLING CRADLE RC CHECKER BANANA BAG RED
39420 ROLLING CRADLE RC CHECKER BANANA BAG BLACK
39421 ROLLING CRADLE RC CHECKER BANANA BAG NAVY
39701 ROLLING CRADLE RCxEVANGELION BIG SHIRT "Give me back... ...Ayanami" Black
39702 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / White
39703 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / Red
39704 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / Gray
39705 ROLLING CRADLE RCxEVANGELION LONG T-SHIRT "Shikinami Asuka Langley" / Black
39706 ROLLING CRADLE RCxEVANGELION T-SHIRT "Rei & Shinji" / Black
39707 ROLLING CRADLE RCxEVANGELION T-SHIRT "Rei & Shinji" / White
39708 ROLLING CRADLE RCxEVANGELION CYCLOPS SHOUT T-SHIRT "EVANGELION:2.0" / White
39709 ROLLING CRADLE RCxEVANGELION CYCLOPS SHOUT T-SHIRT "EVANGELION:2.0" / Black
39840 ROLLING CRADLE SWING CATOP / Purple
39841 ROLLING CRADLE SWING CATOP /Balck
40460 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / White
40461 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / Black
40913 ROLLING CRADLE RC-OW1496 CHECK GOWN Green-Red
40914 ROLLING CRADLE RC-S1497 MAJESTIC BASEBALL SHIRT Black
40915 ROLLING CRADLE RC-T1502 SWEET FOOTBALL TOP Pink-Green
40916 ROLLING CRADLE RC-T1502 SWEET FOOTBALL TOP Green-Blue
40917 ROLLING CRADLE RC-P1507 RC JOGGER PANTS Blue
40922 ROLLING CRADLE RC-T1515 CYCLOPS SHOUT -WATERMELON- White
40923 ROLLING CRADLE RC-T1515 CYCLOPS SHOUT -WATERMELON- Black
40924 ROLLING CRADLE RC-C1546 RC LOGO NEW ERA CAP SNAPBACK Navy
40925 ROLLING CRADLE RC-C1546 RC LOGO NEW ERA CAP SNAPBACK Black
40926 ROLLING CRADLE RC-A1557 RC SMARTPHONE CASE VAGABOND HOOP Multi
41008 ROLLING CRADLE RC-P1466 RC CAMO DOTxDOT SHORTS Khaki
41009 ROLLING CRADLE RC-P1466 RC CAMO DOTxDOT SHORTS Gray
41010 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- White
41011 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- Orange
41012 ROLLING CRADLE RC-T1517 ROLLCRDL -PAINT- Black
41083 ROLLING CRADLE CYCLOPS SHOUT -BLUE JERSEY- / Black
41084 ROLLING CRADLE CYCLOPS SHOUT -BLUE JERSEY- / White
41160 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Black
41161 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Red
41162 ROLLING CRADLE CYCLOPS HOLIDAY -CYCLINGLOPS- / Mint
41163 ROLLING CRADLE CYCLOPS HOLIDAY -WHO YA GONNA CALL?- / Apricot
41264 ROLLING CRADLE CORDUROY SHORTS / Blue
41265 ROLLING CRADLE CORDUROY SHORTS / Beige
41266 ROLLING CRADLE RCxDEVILMAN CYCLOPS SHOUT -DEVILMAN crybaby- / Black
41267 ROLLING CRADLE RCxDEVILMAN CYCLOPS SHOUT -DEVILMAN crybaby- / White
41268 ROLLING CRADLE RCxDEVILMAN "DEVILMAN crybaby" / White
41269 ROLLING CRADLE RCxDEVILMAN "DEVILMAN crybaby" / Black
41270 ROLLING CRADLE RCxDEVILMAN "The DEVILMAN Birth" / White
41271 ROLLING CRADLE RCxDEVILMAN "The DEVILMAN Birth" / Black
41272 ROLLING CRADLE RCxDEVILMAN "AKIRA to MIKI" / Black
41273 ROLLING CRADLE RCxDEVILMAN "AKIRA to MIKI" / White
41274 ROLLING CRADLE RCxDEVILMAN "SATAN to DEVILMAN" / Black
41275 ROLLING CRADLE RCxDEVILMAN "SATAN to DEVILMAN" / White
41356 ROLLING CRADLE WIDE CHECK PANTS / White-Red
41357 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Orange
41358 ROLLING CRADLE RC QUICK POCKET POACH / Orange
41359 ROLLING CRADLE ADORABLE SOX / Yellow
41360 ROLLING CRADLE ADORABLE SOX / Green
41361 ROLLING CRADLE CYCLOPS SOX / White
41362 ROLLING CRADLE CYCLOPS SOX / Black
41363 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Camo
41364 ROLLING CRADLE CYCLOPS SHOUT LARGE BUCKET BAG / Black
41365 ROLLING CRADLE RC QUICK POCKET POACH / Black
41367 ROLLING CRADLE RC QUICK POCKET POACH / Camo
41631 ROLLING CRADLE FLASHY BIG SHIRT / Crazy
41632 ROLLING CRADLE FLASHY BIG SHIRT / Camo
41633 ROLLING CRADLE TO RESPECT JDI / Black-Red
41634 ROLLING CRADLE LEOPARD SHORTS / Gray
41635 ROLLING CRADLE LEOPARD SHORTS / Navy
41636 ROLLING CRADLE RC LOGO T-SHIRT / White
41637 ROLLING CRADLE RC LOGO T-SHIRT / Navy
41638 ROLLING CRADLE RC LOGO T-SHIRT / Black
41639 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Yellow
41640 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Orange
41641 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Pink
41642 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Green
41643 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue
41644 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Purple
41694 ROLLING CRADLE FLORAL SHORTS / White
41695 ROLLING CRADLE FLORAL SHORTS / Black
41696 ROLLING CRADLE DISNEY T-SHIRT "Alice in Wonderland" / White
41697 ROLLING CRADLE DISNEY T-SHIRT "Alice in Wonderland" / Mint
41698 ROLLING CRADLE DISNEY T-SHIRT "Alice in Wonderland" / Black
41699 ROLLING CRADLE DISNEY T-SHIRT "Peter Pan" / White
41700 ROLLING CRADLE DISNEY T-SHIRT "Peter Pan" / Lime
41701 ROLLING CRADLE DISNEY T-SHIRT "Peter Pan" / Black
41702 ROLLING CRADLE DISNEY T-SHIRT "Snow White and the Seven Dwarfs" / White
41703 ROLLING CRADLE DISNEY T-SHIRT "Snow White and the Seven Dwarfs" / Red
41704 ROLLING CRADLE DISNEY T-SHIRT "Snow White and the Seven Dwarfs" / Black
41705 ROLLING CRADLE CYCLOPS CLUTCH BAG / Black
41778 ROLLING CRADLE CREAM SODA SHIRT Green
41779 ROLLING CRADLE CREAM SODA SHIRT Blue
41780 ROLLING CRADLE CREAM SODA SHIRT Black
41796 ROLLING CRADLE CARGO CAMO SHORTS Beige
41797 ROLLING CRADLE CARGO CAMO SHORTS Green
41798 ROLLING CRADLE CREAM SODA SHORTS Mix
41799 ROLLING CRADLE CREAM SODA SHORTS Black
41800 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST BLUE- White
41801 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST BLUE- Black
41802 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST PINK- White
41803 ROLLING CRADLE CYCLOPS SHOUT YOUKAI -FOREST PINK- Black