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 06:14:46')
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 720, 120
32274 ROLLING CRADLE (ロリクレ) Donut of Heart TOTE / Black
32418 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Blue
32419 ROLLING CRADLE GRAVY CHECK BIG SHIRT / Brown
32420 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Burgundy
32421 ROLLING CRADLE R-kn BEACH ZIP HOODIE / Black
32422 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Yellow-Blue
32423 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Blue-Pink
32424 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Purple-Green
32425 ROLLING CRADLE CYCLOPS SHOUT COIN CASE / Black-White
32427 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE NAVY
32428 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE BLACK
32429 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE GRAY
32430 ROLLING CRADLE (ロリクレ) 6090 ALL STAR HOODIE RED
32433 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM INDIGO
32435 ROLLING CRADLE (ロリクレ) THUNDER GATE WIDE DENIM ICEBLUE
32503 ROLLING CRADLE THUNDER GATE DENIM 1st type / Indigo(W)
32542 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT White
32543 ROLLING CRADLE PINEAPPLE ALOHA BIG SHIRT Black
32544 ROLLING CRADLE R-kn BEACH LONG T-SHIRT White
32545 ROLLING CRADLE R-kn BEACH LONG T-SHIRT / Black
33426 ROLLING CRADLE (ロリクレ) RC×RESORTLOVER COCOYASHI SHORTS / Purple
33427 ROLLING CRADLE (ロリクレ) RC×RESORTLOVER COCOYASHI SHORTS / Black
33679 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Beige
33680 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Burgundy
33681 ROLLING CRADLE (ロリクレ) RC STANDARD SHORTS / Blue
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
33927 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Orange
33928 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Sumiblack
33929 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT White
33930 ROLLING CRADLE R-kn BEACH RUNNING T-SHIRT Burgundy
34186 ROLLING CRADLE CATTLE MUTILATION SHIRT / Blackwatch
34187 ROLLING CRADLE CATTLE MUTILATION SHIRT / Blue
34188 ROLLING CRADLE RC JOGGER PANTS / White-Navy
34189 ROLLING CRADLE RC JOGGER PANTS / Green-Black
34190 ROLLING CRADLE CROPPED PANTS / Black
34191 ROLLING CRADLE CROPPED PANTS / Beige
34192 ROLLING CRADLE SQUARE CYCLOPS / White
34193 ROLLING CRADLE SQUARE CYCLOPS / Black
34194 ROLLING CRADLE SQUARE CYCLOPS / Apricot
34195 ROLLING CRADLE SQUARE CYCLOPS / Lavender
34196 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / White
34197 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Black
34198 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Orange
34199 ROLLING CRADLE VAGABOND CYCLOPS -Delicious- / Green
34200 ROLLING CRADLE iPhone Case Note Type / SHOUT
34201 ROLLING CRADLE iPhone Case Note Type / RC ALL STARS
34258 ROLLING CRADLE BIG POCKET SHORTS / Brown
34259 ROLLING CRADLE BIG POCKET SHORTS / Green
34260 ROLLING CRADLE BIG POCKET SHORTS / Red
34261 ROLLING CRADLE RCxTM paint -MVP- / Black
34262 ROLLING CRADLE RCxTM paint -MVP- / White
34263 ROLLING CRADLE RCxTM paint -MVP- / Gray
34264 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / Black
34265 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / White
34266 ROLLING CRADLE RCxTM paint -BOOTLEG FAMILY- / Gray
34267 ROLLING CRADLE CYCLOPS SHOUT -ALL STAR- / White
34268 ROLLING CRADLE CYCLOPS SHOUT -ALL STAR- / Black
34269 ROLLING CRADLE RC GLASSES -ROMA- / Orange
34270 ROLLING CRADLE RC GLASSES -ROMA- / Blue
34271 ROLLING CRADLE RC BATH TOWL HOODIE / Black
34452 ROLLING CRADLE FAKE LAYERED HOODIE / White
34453 ROLLING CRADLE FAKE LAYERED HOODIE / Navy
34454 ROLLING CRADLE Mickey T-SHIRT / White
34455 ROLLING CRADLE Mickey T-SHIRT / Black
34456 ROLLING CRADLE Mickey&Minnie T-SHIRT / White
34457 ROLLING CRADLE Mickey T-SHIRT / Black
34458 ROLLING CRADLE Donald&Daisy T-SHIRT / Black
34459 ROLLING CRADLE Donald&Daisy T-SHIRT / White
34460 ROLLING CRADLE Pooh&Piglet T-SHIRT / White
34461 ROLLING CRADLE Pooh&Piglet T-SHIRT / Black
34462 ROLLING CRADLE RC BANDANA / Blue-Red
34463 ROLLING CRADLE RC BANDANA / Red-Blue
34915 ROLLING CRADLE RCxXEVIOUS -CYCLOPS SHOUT- / White
34916 ROLLING CRADLE RCxPAC-MAN -CYCLOPS SHOUT- / Black
34917 ROLLING CRADLE RCxPAC-MAN -CYCLOPS SHOUT- / White
34918 ROLLING CRADLE RCxXEVIOUS -CYCLOPS SHOUT- / Black
34919 ROLLING CRADLE NEKO CAP / Pink
34920 ROLLING CRADLE NEKO CAP / Black
35023 ROLLING CRADLE RC HATE -All Flavor- / White
35024 ROLLING CRADLE RC HATE -All Flavor- / Black
35025 ROLLING CRADLE ROLLING CRADLE RC HATE -BIKELOPS- / Black
35026 ROLLING CRADLE RC HATE -BIKELOPS- / White
35027 ROLLING CRADLE RC HATE -Donut of Heart- / Black
35028 ROLLING CRADLE RC HATE -Donut of Heart- / White
35029 ROLLING CRADLE KUNG FU CAT SHIRT / White
35030 ROLLING CRADLE KUNG FU CAT SHIRT / Red
35031 ROLLING CRADLE PPkn SNAPBACK / Navy-Red
35032 ROLLING CRADLE PPkn SNAPBACK / Blue
35086 ROLLING CRADLE RC-ANKLET オレンジ
35089 ROLLING CRADLE RC-ANKLET ピンク
35090 ROLLING CRADLE RC-ANKLET ブルー
35181 ROLLING CRADLE RC PINS PP-BLACK
35182 ROLLING CRADLE RC PINS PP-YELLOW
35183 ROLLING CRADLE RC PINS SH-BLACK
35184 ROLLING CRADLE RC PINS SHOUT-GREEN
35185 ROLLING CRADLE RC PINS SHOUT-BLACK
35193 ROLLING CRADLE RC PINS VAGABOND
35196 ROLLING CRADLE RC PINS RC SOXS WHITE
35198 ROLLING CRADLE RC PINS RC SOXS TURQUCISE
35675 ROLLING CRADLE RCxMU THE UFO BEAM SHORTS RED
35677 ROLLING CRADLE RCxMU THE UFO BEAM SHORTS GREEN
35678 ROLLING CRADLE All Flavor of RC BELL HAT Black/White
35681 ROLLING CRADLE All Flavor of RC SHIRT WHITE
35682 ROLLING CRADLE All Flavor of RC SHIRT BLACK
35684 ROLLING CRADLE All Flavor of RC BIG Tee WHITE
35685 ROLLING CRADLE All Flavor of RC BIG Tee BLACK
35686 ROLLING CRADLE All Flavor of RC SHORTS WHITE
35688 ROLLING CRADLE All Flavor of RC SHORTS BLACK
36039 ROLLING CRADLE SMART PHONE RING RED
36040 ROLLING CRADLE SMART PHONE RING BLACK
36282 ROLLING CRADLE RUCKSACK Black
36283 ROLLING CRADLE RUCKSACK Camo
36338 ROLLING CRADLE (ロリクレ) RC QUICK POCKET POACH / Blue
36339 ROLLING CRADLE (ロリクレ) RC QUICK POCKET POACH / Black
36340 ROLLING CRADLE (ロリクレ) RC QUICK POCKET POACH / Red
36523 ROLLING CRADLE GREAT FAVORITE SHIRT White
36524 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- White
36525 ROLLING CRADLE RCxSpongeBob -ROLLCRDL- Blue