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-21 01:22:38')
AND pc.price02 > 909
AND price02 <= 2727
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 447)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
62255 Zephyren(ゼファレン) S/S TEE - VISIONARY - WHITE
62266 Zephyren(ゼファレン) S/S TEE - BEYOND - BLACK
59718 Zephyren(ゼファレン) LONG BEANIE -You Are Here BLACK
59599 Zephyren(ゼファレン) L/S TEE - twilight - WHITE
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
55063 Zephyren(ゼファレン)S/S TEE - BEYOND - AQUA
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
35969 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- WHITE
57724 Zephyren(ゼファレン) iPhone CASE -音のない世界(I Scream)- iPHONE 12/12 Pro
55226 Zephyren(ゼファレン)PAISLEY G.I BELT BEIGE
30786 Zephyren(ゼファレン) PAISLEY G.I BELT NAVY
30810 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BLACK
32491 Zephyren(ゼファレン) NECK STRAP -VISIONARY- BARGUNDY
32493 Zephyren(ゼファレン) NECK STRAP -VISIONARY- WHITE
55047 Zephyren(ゼファレン)S/S TEE - VISIONARY - SKY
55259 Zephyren(ゼファレン)BLACK MASK-VISIONARY- BLACK02
55260 Zephyren(ゼファレン)FACE MASK-VISIONARY- BLACK
55261 Zephyren(ゼファレン)BUFF FACE MASK BLACK
55263 Zephyren(ゼファレン)BUFF FACE MASK NAVY
52037 Zephyren(ゼファレン) BIG S/S TEE -VISIONARY/zebra eye- BLACK
35972 Zephyren (ゼファレン) LONG G.I BELT -VISIONARY- BEIGE
19748 Zephyren (ゼファレン) GYM SOX -VISIONARY - WHITE
33345 Zephyren (ゼファレン) GYM SOX -VISIOBARY- BLACKxWHITE
15223 ZEPHYREN (ゼファレン) TEE S/S -VISONARY- BLK×GLD
15255 ZEPHYREN (ゼファレン) MESH CAP -Thorns fame- BLK
15258 ZEPHYREN (ゼファレン) BEANIE -You Are Here- GRAY
15617 ZEPHYREN (ゼファレン) TEE S/S -Determination- WHT
15642 ZEPHYREN (ゼファレン) TANK TOP -VISONARY- BLK
15644 ZEPHYREN (ゼファレン) TANK TOP ?-VISONARY- GRY
16856 ZEPHYREN (ゼファレン) S/S TEE -THE SUN- DENIM
16861 ZEPHYREN (ゼファレン) S/S TEE -THE SUN- BLK/BGN
17118 Zephyren TANK TOP -BEYOND- - CHARCOAL
17120 ZEPHYREN (ゼファレン) TANK TOP -Determination- WHITE
17121 ZEPHYREN (ゼファレン) TANK TOP -Determination- BLACK
17226 ZEPHYREN (ゼファレン) MESH CAP -BEYOND- BLACK/WHITE
17227 ZEPHYREN (ゼファレン) MESH CAP -BEYOND- BLACK/BURGUNDY
17228 ZEPHYREN (ゼファレン) MESH CAP -BEYOND- BLACK/BLACK
17230 Zephyren MESH CAP -BEYOND- - BURGUNDY
17255 Zephyren MESH CAP -VISIONARY- - DARK.GREEN
17256 Zephyren MESH CAP -VISIONARY- - BURGUNDY
17285 ZEPHYREN (ゼファレン) METAL NECKLACE -VISIONARY- BLACK
17286 ZEPHYREN (ゼファレン) METAL NECKLACE -VISIONARY- GOLD
17287 ZEPHYREN (ゼファレン) METAL NECKLACE -VISIONARY- SILVER
17288 ZEPHYREN (ゼファレン) METAL NECKLACE -VISIONARY- - A.G
17289 ZEPHYREN (ゼファレン) METAL NECKLACE VISIONARY A.S
17290 ZEPHYREN (ゼファレン) METAL NECKLACE -PRAY FOR DESTROY- - BLACK
17291 ZEPHYREN (ゼファレン) METAL NECKLACE -PRAY FOR DESTROY- - GOLD
17292 ZEPHYREN (ゼファレン) METAL NECKLACE -PRAY FOR DESTROY- SILVER
17293 ZEPHYREN (ゼファレン) METAL NECKLACE PRAY FOR DESTROY A.G
17294 ZEPHYREN (ゼファレン) METAL NECKLACE PRAY FOR DESTROY A.S
17295 Zephyren(ゼファレン)METAL NECKLACE -Guadalupe- BLACK
17296 Zephyren(ゼファレン)METAL NECKLACE -Guadalupe- GOLD
17297 Zephyren(ゼファレン)METAL NECKLACE -Guadalupe- SILVER
17298 ZEPHYREN (ゼファレン) METAL NECKLACE Guadalupe ANTIQUE G
17299 ZEPHYREN (ゼファレン) METAL NECKLACE Guadalupe ANTIQUE S
17310 ZEPHYREN (ゼファレン) HAIR GOM -SKULL HEAD- BLACK
17311 ZEPHYREN (ゼファレン) HAIR GOM -SKULL HEAD- GOLD
17312 ZEPHYREN (ゼファレン) HAIR GOM -SKULL HEAD- SILVER-
17313 ZEPHYREN (ゼファレン) HAIR GOM -SKULL HEAD- ANTIQUE GOLD
17314 ZEPHYREN (ゼファレン) HAIR GOM SKULL HEAD ANTIQUE SILVER
17592 ZEPHYREN (ゼファレン) TANK TOP ?-VISONARY- WHITE
18136 ZEPHYREN (ゼファレン) S/S TEE -10-FEET BUR
18137 ZEPHYREN (ゼファレン) S/S TEE -10-FEET BLK
18138 ZEPHYREN (ゼファレン) S/S TEE -10-FEET WHI
18139 ZEPHYREN (ゼファレン) S/S TEE -10-FEET BLK/BUR
18140 ZEPHYREN (ゼファレン) S/S TEE -ROTTENGRAFFTY BLK
18142 ZEPHYREN (ゼファレン) S/S TEE -ROTTENGRAFFTY BLK/BUR
18144 ZEPHYREN (ゼファレン) B.B CAP -10-FEET BLK
18146 ZEPHYREN (ゼファレン) B.B CAP -10-FEET CHA
18147 ZEPHYREN (ゼファレン) B.B CAP -10-FEET NAVY
18148 ZEPHYREN (ゼファレン) B.B CAP -ROTTENGRAFFTY BLK
18149 ZEPHYREN (ゼファレン) B.B CAP -ROTTENGRAFFTY NAVY
18151 ZEPHYREN (ゼファレン) B.B CAP -ROTTENGRAFFTY BUR
19031 ZEPHYREN (ゼファレン) METAL RING -SKULL HEAD- SILVER
19032 ZEPHYREN (ゼファレン) METAL RING -SKULL HEAD- ANTIQUE GOLD
19033 ZEPHYREN (ゼファレン) METAL RING -SKULL HEAD- ANTIQUE SILVER
19716 ZEPHYREN (ゼファレン) METAL RING -VISIONARY - GOLD
19719 Zephyren(ゼファレン)METAL RING -VISIONARY- ANTIQUE.SILVER
19720 ZEPHYREN (ゼファレン) METAL RING -THORN - BLACK
19721 ZEPHYREN (ゼファレン) METAL RING -THORN - GOLD
19722 ZEPHYREN (ゼファレン) METAL RING -THORN - SILVER
19723 ZEPHYREN (ゼファレン) METAL RING -THORN - ANTIQUE GOLD
19724 ZEPHYREN (ゼファレン) METAL RING -THORN - ANTIQUE SILVER
19751 ZEPHYREN (ゼファレン) ASHTRAY -EMBLEM - WHITE
19790 Zephyren BATTERY CHARGER -SKULL HEAD - BLACK
22140 ZEPHYREN (ゼファレン) iPhone CASE -SKULL HEAD-
22141 ZEPHYREN (ゼファレン) iPhone 6 CASE -Scream of Aggression-
22751 Zephyren(ゼファレン)METAL NECKLACE -STUDS CROSS- GOLD
22752 Zephyren(ゼファレン)METAL NECKLACE -STUDS CROSS- SILVER
22755 Zephyren (ゼファレン) STUDS PIERCE ANTIQUE GOLD
22756 Zephyren (ゼファレン) STUDS METAL RING BLACK
22761 Zephyren (ゼファレン) STUDS PIERCE ANTIQUE SILVER
22896 Zephyren (ゼファレン) FLIP iPhone 6 CASE -Scream of Aggression-
24395 Zephyren (ゼファレン) TANK TOP -BEYOND- KHAKI
24917 Zephyren (ゼファレン) LONG BEANIE -You Are Here- CHACOAL
24918 Zephyren (ゼファレン) LONG BEANIE -You Are Here- BURGUNDY
24919 Zephyren (ゼファレン) LONG BEANIE -You Are Here- BLUE
24935 Zephyren (ゼファレン) FLIP iPhone 7 CASE -SKULL HEAD- BLACK
24936 Zephyren (ゼファレン) JET CAP -BEYOND- BLACK
24937 Zephyren (ゼファレン) JET CAP -BEYOND- NAVY
24938 Zephyren (ゼファレン) JET CAP -BEYOND- CHARCOAL
24939 Zephyren (ゼファレン) JET CAP -BEYOND- BEIGE
25107 Zephyren (ゼファレン) MEANINGxZephyren S/S TEE -Precious-
26274 Zephyren (ゼファレン) STUDS PIERCE BLK
26275 Zephyren (ゼファレン) STUDS PIERCE GOLD
26277 Zephyren (ゼファレン) STUDS PIERCE SILVER
26346 Zephyren (ゼファレン) MESH CAP -VISIONARY- BLACKxWHITE
26347 Zephyren (ゼファレン) MESH CAP -VISIONARY- BLACKxBURGUNDY
26349 Zephyren (ゼファレン) MESH CAP -VISIONARY- CAMO I
26352 Zephyren (ゼファレン) MESH CAP -BEYOND- CAMO II
26603 Zephyren (ゼファレン) TANK TOP -BEYOND- BLACKxRED
26604 Zephyren (ゼファレン) TANK TOP -BEYOND- GRAY
26605 Zephyren (ゼファレン) TANK TOP -VISIONARY- BLACKxRED
26908 Zephyren (ゼファレン) TWILL CAP -NY- WHITE
26909 Zephyren (ゼファレン) TWILL CAP -NY- BLACK
26966 Zephyren (ゼファレン) HAIR BAND -You Are Here- BLACK
26967 Zephyren (ゼファレン) HAIR BAND -You Are Here- CHARCOAL
26970 Zephyren (ゼファレン) HAIR BAND -You Are Here- WHITE