SELECT SQL_CALC_FOUND_ROWS p.del_flg AS new_arrival_content, 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-29 03:55:45')
AND pc.price02 > 4545
AND price02 <= 9090
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 349)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 120
69283 TOY MACHINE (トイマシーン) DRUGGED EYES DENIM BUCKET HAT L.BLUE
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63215 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - WHITE
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
65935 TOY MACHINE (トイマシーン) WINGED SECT ROCKET PADDING JACKET-BLACK
66948 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA BLACK
66950 TOY MACHINE (トイマシーン) PEPPER SECT SWEAT PARKA YELLOW
39057 TOY MACHINE TMP18SWT17 tm sect cn PURPLE
39086 TOY MACHINE TMP18SWT17 tm sect cn BLACK
39087 TOY MACHINE TMP18SWT17 tm sect cn MIX GRAY
43309 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW BLACK
43311 TOY MACHINE TMF18SW12 TAPE LOGO SWEAT CREW WHITE
56225 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - SAND
56226 TOY MACHINE TOYMONSTER EMBROIDERY SWEAT CREW - BLACK
56265 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - MIX GREY
56266 TOY MACHINE NO SCOOTER PRINT SWEAT PARKA - BLACK
56269 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - SAND
56270 TOY MACHINE OG MONSTER PRINT SWEAT PARKA - BLACK
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
60536 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - BLACK
60537 TOY MACHINE LOYAL PAWN EMBROIDERY SWEAT CREW - SAND
63773 TOY MACHINE (トイマシーン) TRIPLE PEPPER SECT EMBROIDERY LOOSE FIT CARGO SHORTS - BLAC
65940 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-SAND
65941 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY SWEAT CREW-F.GREEN
66646 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS MUSTARD
66647 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS BLACK
61689 TOY MACHINE (トイマシーン) EYES SWEAT HOODY GRAY
61695 TOY MACHINE (トイマシーン) TM & EYE STADIUM JACKET NAVY
66946 TOY MACHINE (トイマシーン) MARKED MONSTER SWEAT CREW F.GREEN
70769 TOY MACHINE (トイマシーン) (HEAVY WEIGHT) LIVING TOY - TRANSMISSIONATOR LONG TEE WHITE
70770 TOY MACHINE (トイマシーン) (HEAVY WEIGHT) LIVING TOY - TRANSMISSIONATOR LONG TEE GREEN
70771 TOY MACHINE (トイマシーン) (HEAVY WEIGHT) LIVING TOY - TRANSMISSIONATOR LONG TEE BLACK
56223 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - MIX GREY
56224 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - BLACK
58584 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS PINK
58585 TOY MACHINE STRETCH NYLON POCKET SHORT PANTS KHAKI
60539 TOY MACHINE (トイマシーン) SKATE DATE PRINT SWEAT CREW - BLACK
60540 TOY MACHINE SKATE DATE PRINT SWEAT CREW - L. PURPLE
68400 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE NAVY
68401 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE YELLOW
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63226 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - F.GREEN
69437 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT & TOYMOONSTER WHITE
69438 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT & TOYMOONSTER BLACK
69439 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT FALLING DOWN LONG T WHITE
69440 TOY MACHINE (トイマシーン) SKB3 COLLAB. SECT FALLING DOWN LONG T BLACK
70509 TOY MACHINE (トイマシーン) 【Hirotton collab.】Mohawk raglan long tee WHITE×BLACK
70510 TOY MACHINE (トイマシーン) 【Hirotton collab.】Mohawk raglan long tee WHITE×F.GREEN
69203 TOY MACHINE (トイマシーン) ROCKET SECT EMBROIDERY LONG TEE WHITE
69204 TOY MACHINE (トイマシーン) ROCKET SECT EMBROIDERY LONG TEE BLACK
69205 TOY MACHINE (トイマシーン) ROCKET SECT EMBROIDERY LONG TEE D.ORANGE
70516 TOY MACHINE (トイマシーン) LIVING TOY - FIST LONG TEE WHITE
70517 TOY MACHINE (トイマシーン) LIVING TOY - FIST LONG TEE BLACK
70518 TOY MACHINE (トイマシーン) LIVING TOY - FIST LONG TEE L.BLUE
61214 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - BLACK
58022 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BEIGE
58023 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - BLACK
66650 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE WHITE
66651 TOY MACHINE (トイマシーン) SECT EYE EMBROIDERY LONG TEE BLACK
70897 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE WHITE
70898 TOY MACHINE (トイマシーン) MIND CONTROL SS TEE BLACK
70899 TOY MACHINE (トイマシーン) PUZZLE SS TEE WHITE
70900 TOY MACHINE (トイマシーン) PUZZLE SS TEE BLACK
45507 TOY MACHINE TMS19SH33 LINE MONSTER PRINT SHIRT NAVY
56746 TOY MACHINE BOA FLEECE TOTE BAG - WHITE
62540 TOY MACHINE (トイマシーン) TM & EYE BB CAP - BLACK
65948 TOY MACHINE (トイマシーン) OG MONSTER PU LEATHER HAT-BLACK
68821 TOY MACHINE (トイマシーン) SKB3 COLLAB. BALOON SS TEE WHITE
68822 TOY MACHINE (トイマシーン) SKB3 COLLAB. BALOON SS TEE BLACK
71238 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE BLACK
71239 TOY MACHINE (トイマシーン) TMPEST29 TALLY HO SS TEE WHITE
71240 TOY MACHINE (トイマシーン) TRANSMISSIONATOR EMBROIDERY SS TEE F.GREEN
71241 TOY MACHINE (トイマシーン) MARKED MONSTER EMBROIDERY SS TEE BURGANDY
58780 TOY MACHINE BUCKET HAT BLACK
58783 TOY MACHINE BUCKET HAT BLACK
69279 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE WHITE
69280 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE BLACK
51231 TOY MACHINE×PUNK DRUNKERS * FIST LONG TEE - GOLD
51232 TOY MACHINE×PUNK DRUNKERS * FIST LONG TEE - WHITE
51233 TOY MACHINE×PUNK DRUNKERS * FIST LONG TEE - BLACK
51234 TOY MACHINE×PUNK DRUNKERS * TOY SECT LONG TEE - WHITE
51235 TOY MACHINE×PUNK DRUNKERS * TOY SECT LONG TEE - PINK
53970 TOY MACHINE SKATE DATE SST (BIG SIZE) - WHITE
53971 TOY MACHINE SKATE DATE SST (BIG SIZE) - BLACK
54206 TOY MACHINE PRINT POCKET SST (BIG SIZE) - WHITE
54207 TOY MACHINE PRINT POCKET SST (BIG SIZE) - BLACK
58587 TOY MACHINE OG MONSTER SS WIDE TEE WHITE
58588 TOY MACHINE (トイマシーン) OG MONSTER SS WIDE TEE BLACK
63228 TOY MACHINE (トイマシーン) WELCOME TO HELL SS TEE - BLACK
67867 TOY MACHINE (トイマシーン) TALLY HO SS TEE WHITE
67872 TOY MACHINE (トイマシーン) TALLY HO SS TEE BLACK
69218 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY TWILL HAT BLACK
69219 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY TWILL HAT NAVY
69711 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY BEANIE BLACK
69712 TOY MACHINE (トイマシーン) ROBOT&SECT EMBROIDERY BEANIE PURPLE
69713 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE BLACK
69714 TOY MACHINE (トイマシーン) PEPPER SECT EMBROIDERY BEANIE OLIVE
70513 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP BLACK
70514 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP RED
70515 TOY MACHINE (トイマシーン) ROBOT & SECT 2 TONE CAP GRAY
70903 TOY MACHINE (トイマシーン) OG MONSTER DENIM BUCKET HAT Light Wash
70904 TOY MACHINE (トイマシーン) OG MONSTER DENIM BUCKET HAT BLACK
39053 TOY MACHINE TMP18LT2 colintotymachine logo ls WHITE
39055 TOY MACHINE TMF17LT2 toymachine logo Long Tee Black
39079 TOY MACHINE TMP18LT1 turtleboy emb ls BLACK
39080 TOY MACHINE TMP18LT1 turtleboy emb ls PURPLE
39081 TOY MACHINE TMP18LT2 colintotymachine logo ls BLACK
39082 TOY MACHINE TMP18LT2 colintotymachine logo ls PINK
39975 TOY MACHINE Longsleeve tee PINK
40861 TOY MACHINE TMS18ST13 POCKET TEE BLACK
40862 TOY MACHINE TMS18ST13 POCKET TEE WHITE
40864 TOY MACHINE TMS18ST14 POCKET TEE BLACK
41239 TOY MACHINE TMS18ST24 PIGMENT PRINT TEE WHITE
41240 TOY MACHINE TMS18ST24 PIGMENT PRINT TEE BLACK
42919 TOY MACHINE TMF18LT1 SECT_W LST BLACK
42920 TOY MACHINE TMF18LT1 SECT_W LST ORANGE
42929 TOY MACHINE TMF18LT1 SECT_W LST WHITE
45454 TOY MACHINE TMS19ST6 ORIGINAL MONSTER PRINT SS POCKET TEE WHITE
45460 TOY MACHINE TMS19ST6 ORIGINAL MONSTER PRINT SS POCKET TEE BLACK
45486 TOY MACHINE TMS19ST19 SECT STAFF PRINT PIGMENT SS TEE WHITE