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 17:44:18')
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 MAX(price02)
LIMIT 480, 120
36525 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- Blue
36526 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- Black
36527 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- White
36528 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Blue
36529 ROLLING CRADLE RCxSpongeBob -Bob&Patrick- Black
37173 ROLLING CRADLE RCxE.T. E.T.ELLIOT T-SHIRT / White
37175 ROLLING CRADLE RCxE.T. E.T.ELLIOT T-SHIRT / Black
37176 ROLLING CRADLE RCxE.T. ELLIOT BMX T-SHIRT / White
37178 ROLLING CRADLE RCxE.T. ELLIOT BMX T-SHIRT / Black
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
39407 ROLLING CRADLE S. N Tee "TOP OF GLORY"
39408 ROLLING CRADLE S. N Tee "STRONG STYLE HAS ARRIVED" 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
40460 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / White
40461 ROLLING CRADLE RC×B&B Tee "BEAVIS CORNHOLIO" / Black
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
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
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
41804 ROLLING CRADLE RCxGEGEGE "THREE EYES" White
41805 ROLLING CRADLE RCxGEGEGE "THREE EYES" Black
41806 ROLLING CRADLE RCxGEGEGE "NURIKABE" White
41807 ROLLING CRADLE RCxGEGEGE "NURIKABE" Black
41808 ROLLING CRADLE RCxGEGEGE "HYAKUME" White
41809 ROLLING CRADLE RCxGEGEGE "HYAKUME" Black
46231 ROLLING CRADLE WAPPEN TOTE / Stripe
46232 ROLLING CRADLE WAPPEN TOTE / Black
46814 ROLLING CRADLE ROLLCRDL LOGO T-SHIRT / White
46815 ROLLING CRADLE ROLLCRDL LOGO T-SHIRT / Black
48445 ROLLING CRADLExワンパンマン"サイタマ" / Peper
48446 ROLLING CRADLExワンパンマン"ジェノス" / White
48447 ROLLING CRADLExワンパンマン"戦慄のタツマキ" / Blue-jean
54126 ROLLING CRADLE TIEFYE TEE PINK
54127 ROLLING CRADLE TIEFYE TEE YELLOW
54128 ROLLING CRADLE TIEFYE TEE BLUE
54479 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 Tシャツ
66461 ROLLING CRADLE (ローリングクレイドル) CHECK TOTE / YELLOW
69270 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE ASH
69271 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE MINT
69272 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE BLACK
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
60625 ROLLING CRADLE CORDUROY GOKU-BUTO PANTS / BLACK
62181 ROLLING CRADLE GLEN CHECK WIDE PANTS / ORANGE
62182 ROLLING CRADLE GLEN CHECK WIDE PANTS / GRAY
33682 ROLLING CRADLE 80s 3D LOGO T-SHIRT / Gray
33683 ROLLING CRADLE 80s 3D LOGO T-SHIRT / White
33684 ROLLING CRADLE 80s 3D LOGO T-SHIRT / Black
41636 ROLLING CRADLE RC LOGO T-SHIRT / White
41637 ROLLING CRADLE RC LOGO T-SHIRT / Navy
41638 ROLLING CRADLE RC LOGO T-SHIRT / Black
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
58043 ROLLING CRADLE RIP-STOP JACKET BLACK
14287 ROLLING CRADLE BiG CYCLOPS-SB HOODIE / Gray
59229 ROLLING CRADLE TV STATIC BAG BLACK
7871 ROLLING CRADLE BIG TOOTH GUM T Charcoal
13890 ROLLING CRADLE MANEATERS LONG T-SHIRT GRAY
17663 ROLLING CRADLE BiG CYCLOPS POUCH / White
17664 ROLLING CRADLE BiG CYCLOPS POUCH / Black
20569 ROLLING CRADLE WARM UP SWEAT PANTS / Gray
20570 ROLLING CRADLE WARM UP SWEAT PANTS / Blue
24201 ROLLING CRADLE MP-LOPS RAGLAN / Red
24202 ROLLING CRADLE MP-LOPS RAGLAN / Navy
24203 ROLLING CRADLE MP-LOPS RAGLAN / Black
24211 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Orange
24212 ROLLING CRADLE SHOUT & SHOCKING SMILE TOY POUCH / Black
26333 ROLLING CRADLE RC RESORT HAT / White
26334 ROLLING CRADLE RC RESORT HAT / Black
28976 ROLLING CRADLE KANJI SWEAT PANTS / Black
44254 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / White
44255 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Green
44256 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Navy
44257 ROLLING CRADLE RCxDRAGON BALL Z T-SHIRT / Black
44265 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / White
44267 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Purple
44268 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Black
54705 ROLLING CRADLE CHERRY HAT
54706 ROLLING CRADLE CHERRY TOTE
56062 ROLLING CRADLE THUNDER CYCLOPS RAGLAN SLEEVE / BLACK
56797 ROLLING CRADLE SUEDE TRACK JACKET BLACK
62776 ROLLING CRADLE CNS TEE / PURPLE
59142 ROLLING CRADLE LOGO LOGO TEE BLACK
59143 ROLLING CRADLE LOGO LOGO TEE GRAIGE
59144 ROLLING CRADLE LOGO LOGO TEE WHITE
59281 ROLLING CRADLE PEEPS TEE / WHITE
59283 ROLLING CRADLE PEEPS TEE / BLACK
60717 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / RED
21602 ROLLING CRADLE CATTLE MUTILATION HAT / Black-Green
21603 ROLLING CRADLE CATTLE MUTILATION HAT / Black-Blue
54640 ROLLING CRADLE JUDGEMENT TEE NAVY
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
19906 ROLLING CRADLE RC×THRASHER SHORTS / Beige
17601 ROLLING CRADLE POP-ART Tee / White
17602 ROLLING CRADLE POP-ART Tee / Black
58768 ROLLING CRADLE STEP TEE / GRAY
58769 ROLLING CRADLE STEP TEE / BLACK