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-25 15:30:38')
AND pc.price02 > 2727
AND price02 <= 4545
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
69945 ROLLING CRADLE (ローリングクレイドル) HEART CRADLE CAP CHARCOAL
69476 ROLLING CRADLE (ローリングクレイドル) LOGO CAP WHITE
69089 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / WHITE
69088 ROLLING CRADLE (ローリングクレイドル) Re:LIKE A ROBBIE TEE / MELON
69087 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / WHITE
69086 ROLLING CRADLE (ローリングクレイドル) Re:STEP TEE / RED
68077 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / WHITE
68078 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / SAX
68079 ROLLING CRADLE (ローリングクレイドル) ICEE TEE / BLACK
63350 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / SAND
63351 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / WHITE
63349 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / BLACK
62775 ROLLING CRADLE CNS TEE / WHITE
62777 ROLLING CRADLE CNS TEE / BLACK
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
62134 ROLLING CRADLE CIRCLE LOGO BAG GRAY
62117 ROLLING CRADLE Mjolnir TEE / BLACK
60715 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / BLACK
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
60251 ROLLING CRADLE COSPLAY GIRL-MOON- TEE / BEIGE
58622 ROLLING CRADLE SAIKYOU TEE / BLACK
58623 ROLLING CRADLE SAIKYOU TEE / WHITE
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
58313 ROLLING CRADLE BIG CHECK SHORTS / BLACK
56106 ROLLING CRADLE WOOL CARDIGAN / BROWN
55996 ROLLING CRADLE FLIGHT LOGO HAT / BLACK
56088 ROLLING CRADLE COMBI VEST / BROWN
5546 ROLLING CRADLE DOT×DOT NECK WARMER Turquoise
7692 ROLLING CRADLE Gizmobies THE 100t BURGER
8754 ROLLING CRADLE 6090 GLASSES SERIES-MYAGE- Brown
10409 ROLLING CRADLE ROUGHLY KNIT CAP Pink
10535 ROLLING CRADLE UNREASONABLE MONSTER White
10536 ROLLING CRADLE UNREASONABLE MONSTER Indigo
10537 ROLLING CRADLE UNREASONABLE MONSTER Black
10539 ROLLING CRADLE Pillkn NEVER DIE Tee Black
12081 ROLLING CRADLE I’LL PAINT IT White
12082 ROLLING CRADLE I’LL PAINT IT Gray
12083 ROLLING CRADLE I’LL PAINT IT Black
12084 ROLLING CRADLE SUMMER FEELING White
12085 ROLLING CRADLE SUMMER FEELING Blue
12086 ROLLING CRADLE SUMMER FEELING Black
12088 ROLLING CRADLE HOUSE ROCKIN’ Pink
12089 ROLLING CRADLE HOUSE ROCKIN’ Black
12096 RC x MONSTER ROCK x MONSTER ENERGY T-Shirt
12213 ROLLING CRADLE BiG CYCLOPS-Dr.J- Blue
12351 ROLLING CRADLE STOP! CYCLO-KN Lightblue
12368 ROLLING CRADLE MISSILE Pillkn Gray
12370 ROLLING CRADLE MISSILE Pillkn Black
12915 ROLLING CRADLE THE UMA COMPLETE TANK
12918 ROLLING CRADLE LAUNDRY TANK White
13715 ROLLING CRADLE RCxMR SCREAMING NOIZE
13720 ROLLING CRADLE MASTER CYCLOPS BLUE
13721 ROLLING CRADLE MASTER CYCLOPS OLIEVE
13722 ROLLING CRADLE MASTER CYCLOPS RED
13891 ROLLING CRADLE RC OFFICIAL T-MONSTER-WHITE
13892 ROLLING CRADLE RC OFFICIAL T-MONSTER-BLACK
14697 ROLLING CRADLE TURTLES-COWABUNGA- Black
14709 ROLLING CRADLE BIG TURTLOPS-MICHELANGELO-
15151 ROLLING CRADLE ROUGHLY KNIT CAP/ Yellow
15152 ROLLING CRADLE ROUGHLY KNIT CAP/ Green
15153 ROLLING CRADLE ROUGHLY KNIT CAP/ Orange
17370 ROLLING CRADLE ROLLCRDL Tee / White
17372 ROLLING CRADLE ROLLCRDL Tee / Yellow
17373 ROLLING CRADLE ROLLCRDL Tee / Red
17375 ROLLING CRADLE ROLLCRDL Tee / Black
17376 ROLLING CRADLE Pill-kn MIXER Tee / White
17377 ROLLING CRADLE Pill-kn MIXER Tee / Gray
17378 ROLLING CRADLE Pill-kn MIXER Tee / Blue
17379 ROLLING CRADLE Pill-kn MIXER Tee / Black
17862 ROLLING CRADLE RC×STETCH ROCKAWAY BEACHERS / Black
17865 ROLLING CRADLE KO-RI KO-RI Tee / White
17966 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / White
17967 ROLLING CRADLE CYCLOPS SHOUT-BEACH- / Black
18294 ROLLING CRADLE ROLLCRDL Tee / Green
18295 ROLLING CRADLE ROLLCRDL Tee Black/RED
18298 ROLLING CRADLE COFFEE BRAKE Tee / Burgundy
18299 ROLLING CRADLE ROLL CAKE BRAKE Tee / Pink
18300 ROLLING CRADLE ROLL CAKE BRAKE Tee / Black
18967 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / White
18968 ROLLING CRADLE CYCLOPS SHOUT-TIEDYE- / Black
18970 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / White
18971 ROLLING CRADLE CYCLOPS SHOUT-DUNK- / Black
19168 ROLLING CRADLE 6090PICXIE / Black
19902 ROLLING CRADLE CYCLOPS SHOUT POUCH / Blue
20013 ROLLING CRADLE MEHYADO TANK / Black
20014 ROLLING CRADLE FUCK×FUCK TANK / White-Black
20475 RC×MONSTER ROCK JUST DO WHAT YOU WANT! WHITE
20476 RC×MONSTER ROCK JUST DO WHAT YOU WANT!! BLACK
21530 ROLLING CRADLE ROUGHLY KNIT CAP / White
21531 ROLLING CRADLE ROUGHLY KNIT CAP / Gray
21532 ROLLING CRADLE ROUGHLY KNIT CAP / Red
21533 ROLLING CRADLE ROUGHLY KNIT CAP / Navy
21534 ROLLING CRADLE ROUGHLY KNIT CAP / Black
21535 ROLLING CRADLE BiG CYCLOPS YETI POUCH / White
21536 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Pink
21537 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Green
21538 ROLLING CRADLE BiG CYCLOPS YETI POUCH / Black
22034 ROLLING CRADLE RC SOCKS 3PACK / A-set
22035 ROLLING CRADLE RC SOCKS 3PACK / B-set
22036 ROLLING CRADLE RC SOCKS 3PACK / C-set
22191 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / WHT
22192 ROLLING CRADLE CYCLOPS SHOUT MAG&DRIPPER SET / BLK
23895 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Orange
23896 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Black
24590 ROLLING CRADLE VAGABOND CYCLOPS Tee / White
24591 ROLLING CRADLE VAGABOND CYCLOPS Tee / Gray
24592 ROLLING CRADLE VAGABOND CYCLOPS Tee / Black
24593 ROLLING CRADLE SD ROLICLE Tee / White
24594 ROLLING CRADLE SD ROLICLE Tee / Red
24596 ROLLING CRADLE SD ROLICLE Tee / Blue
24597 ROLLING CRADLE SD ROLICLE Tee / Black
24889 ROLLING CRADLE GOOD MORNING NASTY / White
24890 ROLLING CRADLE GOOD MORNING NASTY / Green
24891 ROLLING CRADLE GOOD MORNING NASTY / Black
24894 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-White
24896 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Clear-Black
24897 ROLLING CRADLE 6090 GLASSES SERIES -JOHN- / Black
25044 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / White
25045 ROLLING CRADLE CYCLOPS SHOUT-RC BIT WORLD- / Black
25046 ROLLING CRADLE CYCLOPS SHOUT-BURGER- / Black