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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =1
)AS pcat
LEFT JOIN dtb_products AS p ON p.product_id = pcat.product_id
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-05-01 18:24:13')
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
68400 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE NAVY
68401 TOY MACHINE (トイマシーン) SECT EMBROIDERY BORDER SS TEE YELLOW
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
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
69279 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE WHITE
69280 TOY MACHINE (トイマシーン) (BIG SIZE) WINGED SECT ROCKET EMBROIDERY SS TEE BLACK
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
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
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
45487 TOY MACHINE TMS19ST19 SECT STAFF PRINT PIGMENT SS TEE CHARCOAL
45496 TOY MACHINE TMS19ST27 PYLAMID SECT PRINT TIE-DYE SS TEE RAINBOW
45497 TOY MACHINE TMS19ST27 PYLAMID SECT PRINT TIE-DYE SS TEE PINK
45499 TOY MACHINE TMS19ST27 PYLAMID SECT PRINT TIE-DYE SS TEE LIME
45500 TOY MACHINE TMS19ST29 FIST PRINT TIE-DYE SS TEE RED
45501 TOY MACHINE TMS19ST29 FIST PRINT TIE-DYE SS TEE NAVY
54208 TOY MACHINE SKATE SECT TIE-DYE SST - BLAST
64443 PUNK DRUNKERS × TOY MACHINE 組体操TEE - D.GREEN
62535 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - WHITE
62536 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE TOYMONSTER - BLACK
63211 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - WHITE
64212 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - WHITE
64213 TOY MACHINE×PUNK DRUNKERS AITSU AND THE CHARACTERS SS TEE - BLACK
64215 TOY MACHINE×PUNK DRUNKERS AITSU AND SECT YING YANG SS TEE - MINT
64219 TOY MACHINE×PUNK DRUNKERS SECT FROM AITSU SS TEE - BLACK
48450 TOY MACHINE PTM19ST01 PACMAN GAME OVER SECT EMBRO ST WHITE
48451 TOY MACHINE PTM19ST01 PACMAN GAME OVER SECT EMBRO ST BLACK
48452 TOY MACHINE PTM19ST02 PACMAN TOYMONSTER ST WHITE
48453 TOY MACHINE PTM19ST02 PACMAN TOYMONSTER ST BLACK
48454 TOY MACHINE PTM19ST03 PACMAN PACMONSTER TM ST WHITE
48455 TOY MACHINE PTM19ST03 PACMAN PACMONSTER TM ST BLACK
48456 TOY MACHINE PTM19ST04 PACMAN PACMONSTER SECT ST WHITE
48457 TOY MACHINE PTM19ST04 PACMAN PACMONSTER SECT ST BLACK
67876 TOY MACHINE (トイマシーン) MAD MOUSE COMIC COLLAB BRAIN WASH SS TEE WHITE
67877 TOY MACHINE (トイマシーン) MAD MOUSE COMIC COLLAB BRAIN WASH SS TEE BLACK
41812 TOY MACHINE TMJ118ST1 mouseketter2 st WHITE
41813 TOY MACHINE TMJ118ST1 mouseketter2 st BLACK
69281 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDEY SS TEE WHITE
69282 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDEY SS TEE BLACK
39282 TOY MACHINE TMP18ST12 fist st white
39283 TOY MACHINE TMP18ST12 fist st navy
39284 TOY MACHINE TMP18ST12 fist st pink
40468 TOY MACHINE TMS18ST3 colin provost secxt attack ss
40469 TOY MACHINE TMS18ST3 colin provost secxt attack ss Black
40470 TOY MACHINE TMS18ST3 colin provost secxt attack ss Lime
45433 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE WHITE
45434 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE BLACK
45437 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE PINK
45438 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE YELLOW
45442 TOY MACHINE TMS19ST1 MONSTER MARKED EMBROIDERY SS TEE LIME
45449 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE WHITE
45451 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE BLACK
45453 TOY MACHINE TMS19ST3 DUMPSTER PRINT SS TEE LT.BLUE
45479 TOY MACHINE TMS19ST16 MONSTER MARKED PRINT SS TEE WHITE
45480 TOY MACHINE TMS19ST16 MONSTER MARKED PRINT SS TEE BLACK
45481 TOY MACHINE TMS19ST16 MONSTER MARKED PRINT SS TEE GOLD
45482 TOY MACHINE TMS19ST16 MONSTER MARKED PRINT SS TEE B. GREEN
45483 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE WHITE
45484 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE BLACK
45485 TOY MACHINE TMS19ST17 SECT PROTOP PRINT SS TEE YELLOW
45494 TOY MACHINE TMS19ST25 SECT EYE BOX PRINT SS TEE WHITE
45495 TOY MACHINE TMS19ST25 SECT EYE BOX PRINT SS TEE BLACK
46217 TOY MACHINE TMP19ST28 MONSTER MARKED SS TEE - BLACK
46218 TOY MACHINE TMP19ST28 MONSTER MARKED SS TEE - WHITE
46219 TOY MACHINE TMP19ST28 MONSTER MARKED SS TEE - PINK
46220 TOY MACHINE TMP19ST27 TRANSMISSIONATOR LOGO SS TEE - BLACK
46221 TOY MACHINE TMP19ST27 TRANSMISSIONATOR LOGO SS TEE - WHITE
46222 TOY MACHINE TMP19ST27 TRANSMISSIONATOR LOGO SS TEE - RED
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
58156 TOY MACHINE TURTLEBOY T-Shirt BLACK
62610 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - BLACK
62612 TOY MACHINE (トイマシーン) MOUSKETER SS TEE - WHITE
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63231 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - L.BLUE
68238 TOY MACHINE (トイマシーン) SLING SHOT SS TEE WHITE
68239 TOY MACHINE (トイマシーン) SLING SHOT SS TEE BLACK
68240 TOY MACHINE (トイマシーン) SLING SHOT SS TEE PURPLE
68241 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE BLACK
68242 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE L. YELLOW
68243 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE WHITE
71432 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE WHITE
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
58158 TOY MACHINE MONSTER T-Shirt BLUE
58591 TOY MACHINE CHARACTERS SS TEE PINK
63233 TOY MACHINE (トイマシーン) AXEL SS TEE - BLACK
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
63675 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - ORANGE
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
64442 PUNK DRUNKERS x TOY MACHINE 組体操TEE - SUMI
39276 TOY MACHINE TMP18ST7 camo monster st black
39277 TOY MACHINE TMP18ST7 camo monster st white
39278 TOY MACHINE TMP18ST7 camo monster st yellow
39279 TOY MACHINE TMP18ST8 dotmonster st black