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-28 22:46:01')
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 120, 120
65342 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-MUSTARD
65343 TOY MACHINE (トイマシーン) LOOSE FIT COLOR PAINTER PANTS-GREEN
69276 TOY MACHINE (トイマシーン) VACCINE LOOSE FIT SS SHIRTS BLACK
69720 TOY MACHINE (トイマシーン) LAST SUPPER SWEAT PARKA BLACK
69721 TOY MACHINE (トイマシーン) LAST SUPPER SWEAT PARKA ASH GRAY
61213 TOY MACHINE TM × SOUTHPARK COLLABO SWEAT PARKA - BLACK
50804 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつパーカ BLACK
50805 PUNK DRUNKERS [PDSxTOY MACHINE]MONSTERxあいつパーカ M.GRAY
51236 TOY MACHINE×PUNK DRUNKERS TOY DRUNKERS SWEAT PARKA - BLACK
51237 TOY MACHINE×PUNK DRUNKERS TOY DRUNKERS SWEAT PARKA - WHITE
69722 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA NAVY
69723 TOY MACHINE (トイマシーン) BLOOD HAND SWEAT PARKA CAMEL
39058 TOY MACHINE TMP18SW14 bloodsucking po TURQUOISE
39059 TOY MACHINE TMP18SW15 fist po BLACK
39088 TOY MACHINE TMP18SW14 bloodsucking po NAVY
39089 TOY MACHINE TMP18SW14 bloodsucking po BLACK
39090 TOY MACHINE TMP18SW15 fist po YELLOW
39209 TOY MACHINE TMP18PT27 TRACK PANTS BLACK
39210 TOY MACHINE TMP18PT27 TRACK PANTS NAVY
39211 TOY MACHINE TMP18PT28 TRACK PANTS BLACK
39212 TOY MACHINE TMP18PT28 TRACK PANTS NAVY
39253 TOY MACHINE TMP18SW15 fist po GRAY
43295 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA WHITE
43296 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA BLACK
43299 TOY MACHINE TMF18SW7 TAPE LOGO SWEAT PARKA RED
43300 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA BLACK
43302 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA WHITE
43304 TOY MACHINE TMF18SW9 SQUARE MONSTER SWEAT PARKA GRAY
43306 TOY MACHINE TMF18SW10 DOUBLE MOUSEKATER SWEAT PARKA WHITE
43308 TOY MACHINE TMF18SW10 DOUBLE MOUSEKATER SWEAT PARKA BLACK
45572 TOY MACHINE TMP19SW14 RIP TORN MONSTER SWEAT PARKA WHITE
45573 TOY MACHINE TMP19SW14 RIP TORN MONSTER SWEAT PARKA BLACK
51213 TOY MACHINE TMF19SW15 MONSTER MARKED EMBRO SWEAT PARKA BLACK
51214 TOY MACHINE TMF19SW15 MONSTER MARKED EMBRO SWEAT PARKA WHITE
51215 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BLACK
51216 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BLACK
51217 TOY MACHINE TMF19SW16 BRAINWASH SLEEVE PRINT SWEAT PARKA BURGANDY
52596 TOY MACHINE TMP20SW15 PULLOVER PARKA BLACK
52598 TOY MACHINE TMP20SW15 PULLOVER PARKA ASH GRAY
52930 TOY MACHINE TMBT02 WIDE EASY PANTS BEIGE
52931 TOY MACHINE TMBT02 WIDE EASY PANTS BLACK
54202 TOY MACHINE NEON PRINT SS SHIRT - WINE
54203 TOY MACHINE NEON PRINT SS SHIRT - BLACK
54205 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - YELLOW
56227 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BLACK
56228 TOY MACHINE STRETCH CORDUROY SAKTE PANTS - BEIGE
56267 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - BLACK
56268 TOY MACHINE FIST EMBROIDERY SWEAT PARKA - WHITE
58029 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - L. PINK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
65937 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLACK
65938 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-BLUE
65939 TOY MACHINE (トイマシーン) TOYMACHINE VACCINE CORDUROY BIG SHIRTS-M.BROWN
65942 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BLACK
65943 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-TAN
65944 TOY MACHINE (トイマシーン) PYRAMID SECT EMBROIDERY SWEAT PARKA-BROWN
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