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-23 21:56:46')
AND pc.price02 > 4545
AND price02 <= 9090
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 0, 120
69474 ROLLING CRADLE (ローリングクレイドル) CREAM LONGSLEEVE WHITE
69475 ROLLING CRADLE (ローリングクレイドル) CREAM LONGSLEEVE EMERALD
69270 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE ASH
69271 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE MINT
69272 ROLLING CRADLE (ローリングクレイドル) Two Buzz TEE BLACK
66461 ROLLING CRADLE (ローリングクレイドル) CHECK TOTE / YELLOW
66307 幽遊白書×ROLLING CRADLE 幽助 TEE / BLACK
66306 幽遊白書×ROLLING CRADLE 幽助 TEE / EMERALD
66309 幽遊白書×ROLLING CRADLE 桑原 TEE / BLACK
66308 幽遊白書×ROLLING CRADLE 桑原 TEE / BLUE
66311 幽遊白書×ROLLING CRADLE 飛影 TEE / BLACK
66310 幽遊白書×ROLLING CRADLE 飛影 TEE / PURPLE
66313 幽遊白書×ROLLING CRADLE 蔵馬 TEE / BLACK
66312 幽遊白書×ROLLING CRADLE 蔵馬 TEE / PURPLE
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
65803 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BURGUNDY
65804 ROLLING CRADLE(ローリングクレイドル) YF LONG SLEEVE BLACK
64962 ROLLING CRADLE RC x KUDAN LOGO TEE / BLACK
64963 ROLLING CRADLE RC x KUDAN LOGO TEE / WHITE
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
62587 ROLLING CRADLE BURNED LOGO LONG SLEEVE / YELLOW
62588 ROLLING CRADLE BURNED LOGO LONG SLEEVE / BLACK
62181 ROLLING CRADLE GLEN CHECK WIDE PANTS / ORANGE
62182 ROLLING CRADLE GLEN CHECK WIDE PANTS / GRAY
62135 ROLLING CRADLE CIRCLE LOGO BAG BLACK
62776 ROLLING CRADLE CNS TEE / PURPLE
60765 ROLLING CRADLE LOGO ROSE HOODIE / BLACK
60703 ROLLING CRADLE LOGO ROSE LONG SLEEVE / BLACK
60717 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / RED
60625 ROLLING CRADLE CORDUROY GOKU-BUTO PANTS / BLACK
60544 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / NAVY
60550 ROLLING CRADLE THUNDER GATE BAGGY DENIM -2nd- / INDIGO
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
60456 ROLLING CRADLE CHECK FLARE PANTS / YELLOW
60457 ROLLING CRADLE CHECK FLARE PANTS / BLUE
60249 ROLLING CRADLE MAGAZINE TEE / WHITE
60250 ROLLING CRADLE MAGAZINE TEE / BEIGE
60252 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / KHAKI
59279 ROLLING CRADLE BORDER TURTLE NECK / BLUE
59281 ROLLING CRADLE PEEPS TEE / WHITE
59283 ROLLING CRADLE PEEPS TEE / BLACK
56608 ROLLING CRADLE THUNDER GATE DENIM -1st damage type- / BLUE
59228 ROLLING CRADLE TV STATIC HAT BLACK
59229 ROLLING CRADLE TV STATIC BAG BLACK
59143 ROLLING CRADLE LOGO LOGO TEE GRAIGE
59144 ROLLING CRADLE LOGO LOGO TEE WHITE
59142 ROLLING CRADLE LOGO LOGO TEE BLACK
58768 ROLLING CRADLE STEP TEE / GRAY
58769 ROLLING CRADLE STEP TEE / BLACK
57789 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / BLACK
58120 ROLLING CRADLE RIDER LONG SLEEVE / BROWN
58118 ROLLING CRADLE RIDER LONG SLEEVE / WHITE
58119 ROLLING CRADLE RIDER LONG SLEEVE / GREEN
58043 ROLLING CRADLE RIP-STOP JACKET BLACK
58013 ROLLING CRADLE THUNDER GATE SKINNY DENIM / INDIGO
58014 ROLLING CRADLE THUNDER GATE SKINNY DENIM / CHEMICAL
57804 ROLLING CRADLE LMS HAT / GRAIGE
57805 ROLLING CRADLE LMS HAT / BLACK
57806 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / A-TYPE
57807 ROLLING CRADLE RCxHigh-Me TOKYO "PIERCE -HEART-" / B-TYPE
57808 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / A-TYPE
57809 ROLLING CRADLE RCxHigh-Me TOKYO "EARRING -HEART-" / B-TYPE
57788 ROLLING CRADLE 天使と悪魔 LONG SLEEVE / WHITE
57790 ROLLING CRADLE RCxHigh-Me TOKYO "BANGLE" / RED
57791 ROLLING CRADLE RCxHigh-Me TOKYO "EARCUFF" / RED
56797 ROLLING CRADLE SUEDE TRACK JACKET BLACK
56089 ROLLING CRADLE COMBI VEST / RED
56260 ROLLING CRADLE CIRCLE LOGO LONG SLEEVE / NAVY
56261 ROLLING CRADLE CIRCLE LOGO LONG SLEEVE / EMERALD
56174 ROLLING CRADLE SF FAMILY LOGO SLEEVE / BLUE
56175 ROLLING CRADLE SF FAMILY LOGO SLEEVE / WHITE
56062 ROLLING CRADLE THUNDER CYCLOPS RAGLAN SLEEVE / BLACK
55993 ROLLING CRADLE FLIGHT LOGO TEE / WHITE
55994 ROLLING CRADLE FLIGHT LOGO TEE / BLACK
55995 ROLLING CRADLE NEW ERA CAP 59FIFTY-CIRCLE LOGO- / NAVY
55991 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / BERRY
55992 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / PEPPER
54479 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 Tシャツ
54480 【バンドリ!×ゲキクロ第1弾復刻】ROLLING CRADLE×山吹沙綾コラボ 限定 キャップ
7871 ROLLING CRADLE BIG TOOTH GUM T Charcoal
11860 ROLLING CRADLE STREET RC FIGHTERS XV White
12641 ROLLING CRADLE RC-BA TANK Lightblue×Red
12642 ROLLING CRADLE RC-BA TANK Red×Blue
12683 ROLLING CRADLE RC-BA TANK White×Black
12865 ROLLING CRADLE RC DAYPACK Laundry
13890 ROLLING CRADLE MANEATERS LONG T-SHIRT GRAY
14287 ROLLING CRADLE BiG CYCLOPS-SB HOODIE / Gray
14294 ROLLING CRADLE DOT SNAKE WALLET COAD / White
14296 ROLLING CRADLE DOT SNAKE WALLET COAD / Orange
14300 ROLLING CRADLE DOT SNAKE WALLET COAD / Green
14728 ROLLING CRADLE THE UMA COMPLETE DOWN MUFFLER / Nav
14729 ROLLING CRADLE THE UMA COMPLETE DOWN MUFFLER / BLK
16667 ROLLING CRADLE POP-ART LONG T-SHIRT / Black
16668 ROLLING CRADLE POP-ART LONG T-SHIRT / White
17601 ROLLING CRADLE POP-ART Tee / White
17602 ROLLING CRADLE POP-ART Tee / Black
17663 ROLLING CRADLE BiG CYCLOPS POUCH / White
17664 ROLLING CRADLE BiG CYCLOPS POUCH / Black
17747 ROLLING CRADLE B X W NAPZAC / Black
17857 ROLLING CRADLE BiG CYCLOPS-SB / White
17858 ROLLING CRADLE BiG CYCLOPS-SB / Black
17961 ROLLING CRADLE 90's BIG POLO SHIRTS / Navy
17962 ROLLING CRADLE 90's BIG POLO SHIRTS / Black
18292 ROLLING CRADLE 22[TWO-FU] FOOTBALL Tee / Navy
19142 ROLLING CRADLE RC×Mark Gonzales ANGEL White
19161 ROLLING CRADLE RC×Mark Gonzales CLOUD / White
19162 ROLLING CRADLE RC×Mark Gonzales CLOUD / Gray
19163 ROLLING CRADLE RC×Mark Gonzales CLOUD / Black
19164 ROLLING CRADLE RC×Mark Gonzales SKATE / Black
19165 ROLLING CRADLE RC×Mark Gonzales ANGEL / Black
19166 ROLLING CRADLE RC×Mark Gonzales ANGEL / Gray
19906 ROLLING CRADLE RC×THRASHER SHORTS / Beige
19956 ROLLING CRADLE RCxGREMLINS MOHAWK / White
19957 ROLLING CRADLE RCxGREMLINS MOHAWK / Gray
19958 ROLLING CRADLE RCxGREMLINS MOHAWK / Black
19959 ROLLING CRADLE RCxGREMLINS FLASHER / Black
20104 ROLLING CRADLE CATTEL MUTILATION BIG Tee / Turquoi
20105 ROLLING CRADLE CATTEL MUTILATION BIG Tee / White
20569 ROLLING CRADLE WARM UP SWEAT PANTS / Gray