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 04:09:47')
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 360, 120
56272 TOY MACHINE BOA FLEECE BUCKET HAT WHITE
67876 TOY MACHINE (トイマシーン) MAD MOUSE COMIC COLLAB BRAIN WASH SS TEE WHITE
67877 TOY MACHINE (トイマシーン) MAD MOUSE COMIC COLLAB BRAIN WASH SS TEE BLACK
66648 TOY MACHINE (トイマシーン) SECT VS LO SANGELES LONG TEE WHITE
66649 TOY MACHINE (トイマシーン) SECT VS LO SANGELES LONG TEE BLACK
57317 TOY MACHINE LOYAL PAWN BOMBER JACKET(OLIVE)
60541 TOY MACHINE (トイマシーン) PEPPER SECT COTTON DUCK JACKET - BLACK
41812 TOY MACHINE TMJ118ST1 mouseketter2 st WHITE
41813 TOY MACHINE TMJ118ST1 mouseketter2 st BLACK
48458 TOY MACHINE PTM19HW06 PACMAN GAMEOVER SECT CAP BLACK
48459 TOY MACHINE PTM19HW06 PACMAN GAMEOVER SECT CAP NAVY
48460 TOY MACHINE PTM19HW07 PACMAN PACMONSTER TM CAP BLACK
61561 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - BLACK
61693 TOY MACHINE (トイマシーン) FLAME FIST BB CAP RED
65340 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-BLACK
69281 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDEY SS TEE WHITE
69282 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDEY SS TEE BLACK
39052 TOY MACHINE TMP18LT1 turtleboy emb ls WHITE
39054 TOY MACHINE TMP18LT3 dot toymonster ls WHITE
39056 TOY MACHINE TMP18LT6 axel boardslide ls WHITE
39061 TOY MACHINE TMP18BC20 american monster bbc BLACK
39062 TOY MACHINE TMP18BC21 sect eye bbc BLUE
39083 TOY MACHINE TMP18LT3 dot toymonster ls BLACK
39084 TOY MACHINE TMP18LT3 dot toymonster ls ORANGE
39085 TOY MACHINE TMP18LT6 dot toymonster ls BLACK
39091 TOY MACHINE TMP18BC20 american monster bbc WHITE
39092 TOY MACHINE TMP18BC21 sect eye bbc NAVY
39206 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Purple
39282 TOY MACHINE TMP18ST12 fist st white
39283 TOY MACHINE TMP18ST12 fist st navy
39284 TOY MACHINE TMP18ST12 fist st pink
39969 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Orange
39970 TOY MACHINE TMF17HW10 toymachine sectsx Knit Beanie Charcharl
39971 TOY MACHINE TMF18LT5 toymachine logo Long Tee Black
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
40865 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK
40866 TOY MACHINE TMS18CP18 BASEBALL CAP BLACK/RED
41241 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP BLACK
41242 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP GRAY
41243 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP RED
41244 TOY MACHINE TMS18CP28 PIGMENT SIX PANEL CAP GREEN
42921 TOY MACHINE TMF18LT4 FIST_M LST WHITE
42922 TOY MACHINE TMF18LT4 FIST_M LST BLACK
42923 TOY MACHINE TMF18LT4 FIST_M LST PURPLE
42924 TOY MACHINE TMF18LT5 TOYMONSTER MARKED WHITE
42925 TOY MACHINE TMF18LT5 TOYMONSTER MARKED BLACK
42926 TOY MACHINE TMF18LT6 SECT_W LST WHITE
42927 TOY MACHINE TMF18LT6 SECT_W LST BLACK
42928 TOY MACHINE TMF18LT6 SECT_W LST PINK
45130 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) WHITE
45131 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) BLACK
45132 TOY MACHINE TMP19LT3 TAPE LOGO PT LT(LONG TEE) GRAY
45133 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) WHITE
45134 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) BLACK
45135 TOY MACHINE TMP19LT5 SKATE DATE PT LT(LONG TEE) RED
45136 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) WHITE
45137 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) BLACK
45138 TOY MACHINE TMP19LT6 SECT ATTACK PT LT(LONG TEE) NAVY
45141 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP BLACK
45142 TOY MACHINE TMP19HW12 PYLAMID SECT EBRO CAP RED
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
45471 TOY MACHINE TMS19HW8 MONSTER MARKED EMBROIDERY CAP CHARCOAL
45472 TOY MACHINE TMS19HW8 MONSTER MARKED EMBROIDERY CAP GOLD
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
45490 TOY MACHINE TMS19HW23 TAPE LOGO EMBROIDERY CAP BLACK
45491 TOY MACHINE TMS19HW23 TAPE LOGO EMBROIDERY CAP BEIGE
45492 TOY MACHINE TMS19HW24 MONSTER MARKED EMBROIDERY HAT BEIGE
45493 TOY MACHINE TMS19HW24 MONSTER MARKED EMBROIDERY HAT BLACK
45494 TOY MACHINE TMS19ST25 SECT EYE BOX PRINT SS TEE WHITE
45495 TOY MACHINE TMS19ST25 SECT EYE BOX PRINT SS TEE BLACK
45587 TOY MACHINE TMP19HW21 DISTRESSED TOY EMBRO CAP BLACK
45588 TOY MACHINE TMP19HW21 DISTRESSED TOY EMBRO CAP NAVY
45964 TOY MACHINE TMP19LT23 L/S TEE WHITE
45965 TOY MACHINE TMP19LT23 L/S TEE BLACK
45966 TOY MACHINE TMP19LT23 L/S TEE GREEN
45967 TOY MACHINE TMP19LT24 L/S TEE WHITE
45968 TOY MACHINE TMP19LT24 L/S TEE BLACK
45969 TOY MACHINE TMP19LT24 L/S TEE GOLD
46214 TOY MACHINE TMP19HW29 COLLIN TOY LOGO EMBRO CAP - NAVY
46215 TOY MACHINE TMP19HW29 COLLIN TOY LOGO EMBRO CAP - GRAY
46216 TOY MACHINE TMP19HW30 SECT WAX EMBRO CAP - 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
51208 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE BLACK
51209 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE F.GREEN
51210 TOY MACHINE TMF19HW24 BLOOD SUCKING BEANIE GOLD
51211 TOY MACHINE TMF19HW17 EMBRO CORDY CAP BLACK
51212 TOY MACHINE TMF19HW17 EMBRO CORDY CAP TAN
52934 TOY MACHINE TMP20HW26 CAP BLACK
52935 TOY MACHINE TMP20HW26 CAP NAVY
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
53163 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE ORANGE
53164 TOY MACHINE TMS20HW12 BB CAP BLACK
53165 TOY MACHINE TMS20HW12 BB CAP NAVY
55945 TOY MACHINE TOYMONSTER BB CAP - BLACK
56262 TOY MACHINE MONSTER MARKED EMBROIDERY BEANIE - BLACK
56263 TOY MACHINE FIST EMBROIDERY BEANIE - BLACK
56264 TOY MACHINE SECT WAX EMBROIDERY BEANIE - BLACK
57112 TOY MACHINE CLAIRVOYANT LONG TEE WHITE
57113 TOY MACHINE CLAIRVOYANT LONG TEE NEON YELLOW
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK