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 19:47:26')
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 0, 120
12222 ROLLING CRADLE LAUNDRY CAN BADGE
12220 ROLLING CRADLE ALIEN CAN BADGE Red
12221 ROLLING CRADLE ALIEN CAN BADGE Blue
12367 ROLLING CRADLE SUPER LIKE BEER CAN BADGE Black
57793 ROLLING CRADLE LMS SOX / WHITE
60713 ROLLING CRADLE FLOWER SOX / WHITE
60714 ROLLING CRADLE FLOWER SOX / GREEN
24224 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER BLK
24225 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER BLUE
24226 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER GRN
24227 ROLLING CRADLE CYCLOPS SHOUT KEYHOLDER RED
50255 ROLLING CRADLE CANVAS BAG / Natural
12365 ROLLING CRADLE roll-ING CAN BADGE Black
58017 ROLLING CRADLE FIRE SOX / BLACK
60711 ROLLING CRADLE LMS SOX / RED
50561 ROLLING CRADLE RUBBER LOGO NECKLACE / Orange
50562 ROLLING CRADLE RUBBER LOGO NECKLACE / Green
21595 ROLLING CRADLE CYCLOPS HAIR BAND RED
21596 ROLLING CRADLE CYCLOPS HAIR BAND BLUE
21597 ROLLING CRADLE CYCLOPS HAIR BAND YELLOW
21598 ROLLING CRADLE CYCLOPS HAIR BAND GREEN
21599 ROLLING CRADLE CYCLOPS HAIR BAND PINK
21600 ROLLING CRADLE CYCLOPS HAIR BAND PURPLE
56023 ROLLING CRADLE SF FAMILY HAND TOWEL / PINK
24595 ROLLING CRADLE SD ROLICLE Tee / Pruple
50040 ROLLING CRADLE MONSTER TEE/Mintgreen
60253 ROLLING CRADLE OTAKU-SHOJO TEE / WHITE
60254 ROLLING CRADLE OTAKU-SHOJO TEE / BLACK
12858 ROLLING CRADLE RC DRY CLOTH Laundry
12860 ROLLING CRADLE RC DRY CLOTH Finger-Black
17859 ROLLING CRADLE CYCLOPS SKATE IN THE DARKNESS / WHT
15940 ROLLING CRADLE RC LOGO KEY HOLDER / White
15941 ROLLING CRADLE RC LOGO KEY HOLDER / Yellow
15942 ROLLING CRADLE RC LOGO KEY HOLDER / Red
15943 ROLLING CRADLE RC LOGO KEY HOLDER / Black
22013 ROLLING CRADLE Trooper T-shirt BLK
35086 ROLLING CRADLE RC-ANKLET オレンジ
35089 ROLLING CRADLE RC-ANKLET ピンク
35090 ROLLING CRADLE RC-ANKLET ブルー
35196 ROLLING CRADLE RC PINS RC SOXS WHITE
35198 ROLLING CRADLE RC PINS RC SOXS TURQUCISE
41359 ROLLING CRADLE ADORABLE SOX / Yellow
41360 ROLLING CRADLE ADORABLE SOX / Green
41361 ROLLING CRADLE CYCLOPS SOX / White
41362 ROLLING CRADLE CYCLOPS SOX / Black
50558 ROLLING CRADLE ROLICLE SOX / White
50559 ROLLING CRADLE ROLICLE SOX / Navy
52675 ROLLING CRADLE STICKER SET
54522 ROLLING CRADLE DRAW LOGO SOX
54523 ROLLING CRADLE LOGO SOX
55997 ROLLING CRADLE STICKER SET
21601 ROLLING CRADLE CYCLOPS SHOUT GLOVE / Black
38165 ROLLING CRADLE CYCLOPS SHOUT GLOVE / Black
44266 ROLLING CRADLE RCxDr.スランプ アラレちゃん T-SHIRT / Red
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
34462 ROLLING CRADLE RC BANDANA / Blue-Red
34463 ROLLING CRADLE RC BANDANA / Red-Blue
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
36039 ROLLING CRADLE SMART PHONE RING RED
36040 ROLLING CRADLE SMART PHONE RING 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
43430 ROLLING CRADLE RC PINS / Logo
43431 ROLLING CRADLE RC PINS / Florida
43432 ROLLING CRADLE RC PINS / Dragon
43433 ROLLING CRADLE RC PINS / Golira
59282 ROLLING CRADLE PEEPS TEE / EMERALD
60716 ROLLING CRADLE COSPLAY GIRL-THUNDER- TEE / EMERALD
44258 ROLLING CRADLE RCxDRAGON BALL Z SOX / Orange
44259 ROLLING CRADLE RCxDr.スランプ アラレちゃん SOX / Pink
57792 ROLLING CRADLE LMS SOX / BLACK
58016 ROLLING CRADLE FIRE SOX / WHITE
60712 ROLLING CRADLE LMS SOX / BLUE
63886 ROLLING CRADLE (ローリングクレイドル) RC STAR SOX / ORANGE
63887 ROLLING CRADLE (ローリングクレイドル) RC STAR SOX / GREEN
63888 ROLLING CRADLE (ローリングクレイドル) RC STAR SOX / ICEBLUE
48271 ROLLING CRADLE SUPER BIG TEE / Charcoal
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
62116 ROLLING CRADLE Mjolnir TEE / WHITE
64974 ROLLING CRADLE RC x KUDAN LOGO SOX / PINK
64975 ROLLING CRADLE RC x KUDAN LOGO SOX / BLUE
60704 ROLLING CRADLE LOGO ROSE LONG SLEEVE / PINK
28239 ROLLING CRADLE RCxTHRASHER THRASHE'M ALL!! TEE WHT
28981 ROLLING CRADLE CYCLOPS SHOUT CIRCLE POUCH / Beige
37074 ROLLING CRADLE RC LEATHER WRIST BAND / Navy
37075 ROLLING CRADLE RC LEATHER WRIST BAND / Olive
37076 ROLLING CRADLE RC LEATHER WRIST BAND / Red
54125 ROLLING CRADLE JUDGEMENT BIG TEE
59145 ROLLING CRADLE LIP RINGER TEE BLACK
59146 ROLLING CRADLE LIP RINGER TEE GRAIGE
52744 ROLLING CRADLE TYEDIE SOX PINK
52745 ROLLING CRADLE TYEDIE SOX ORANGE
66464 ROLLING CRADLE (ローリングクレイドル) CHECK TOTE / NAVY
56105 ROLLING CRADLE BOUCLE TURTLE NECK / PINK
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
23895 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Orange
23896 ROLLING CRADLE SHOUT & SHOCKING SMILE VENLY CASE / Black
28978 ROLLING CRADLE CYCLOPS SHOUT PEN CASE / Beige
10409 ROLLING CRADLE ROUGHLY KNIT CAP Pink
15151 ROLLING CRADLE ROUGHLY KNIT CAP/ Yellow
15152 ROLLING CRADLE ROUGHLY KNIT CAP/ Green
15153 ROLLING CRADLE ROUGHLY KNIT CAP/ Orange
21530 ROLLING CRADLE ROUGHLY KNIT CAP / White
21531 ROLLING CRADLE ROUGHLY KNIT CAP / Gray
21532 ROLLING CRADLE ROUGHLY KNIT CAP / Red