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 20:55:55')
AND pc.price02 > 2727
AND price02 <= 4545
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 365)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
63293 Anti Social Social Club Kkoch Black Cap
60163 Anti Social Social Club I SEE GREEN BLACK TEE
60164 Anti Social Social Club I SEE GRAPE BLACK TEE
60147 Anti Social Social Club BE MY BUTTERFLY BLACK MESH SHORTS
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
57289 FOG ESSENTIALS FRONT LOGO LS TEE BLACK
57290 FOG ESSENTIALS FRONT LOGO LS TEE TAN
57291 FOG ESSENTIALS FRONT LOGO LS TEE CREAM
56771 FOG ESSENTIALS RIFLECTOR LOGO LS TEE TAN
55894 SALUTE WASHED FLOWER VINTAGE TEE PURPLE
56208 Anti Social Social Club Read Receipts White Tee
56211 Anti Social Social Club California Black Tee
56218 Anti Social Social Club See Right Thru Me Black Belt
56221 Anti Social Social Club My Bad Side Pink
56110 N.B.O. FLOWER PATCH SWEATER KHAKI
56125 N.B.O. SPHERE PRINT T
56126 N.B.O. WASH UFO T
55899 PARADOX HALF SLEEVE T-SHIRTS-FARCE BLACK
55626 Anti Social Social Club THE GROVE BLACK TEE
54747 Dezzn Savior Shirt BLACK
7255 REBEL8 GOO BLOCK BLACK TANK
9054 REBEL8 ALPINE RUST BEANIE
9192 BLACK CRAFT Crypt Keeper T-Shirt
9193 BLACK CRAFT The Diabolical Goat T-Shirt
9195 BLACK CRAFT Hail Satan And Drink Coffee T-Shirt
9197 BLACK CRAFT Lucipurr T-Shirt
9202 BLACK CRAFT Ouija T-Shirt
9203 BLACK CRAFT Sacrifice T-Shirt
9205 BLACK CRAFT Tarot Card T-Shirt
9206 BLACK CRAFT Home Sweet Home T-Shirt
11119 REBEL8 STANDARD ISSUE CANVAS WALLET
11290 BLACK CRAFT Death To Gods T-Shirt
11292 BLACK CRAFT Believe In Yourself Tarot Card T-Shirt
11312 BLACK CRAFT New Pope T-Shirt
11316 BLACK CRAFT Blackcraft Beanie
11375 BLACK CRAFT One Nation No God Tank Top BLACK
11393 BLACK CRAFT Jesus Enslaves T-Shirt
12596 REBEL8 SPREAD THE EIGHT BLACK TANK
14629 REBEL8 ZEUS BELT
15079 REBEL8 YELLOW POM BEANIE
15080 REBEL8 JOIN OR DIE GREY POM BEANIE
15083 REBEL8 WATCH YOUR STEP GREY BEANIE
15565 FAR★STAR 百目 トートバッグ
15568 FAR★STAR 百目 マルチネックウォーマー
15821 BLACK CRAFT Saint Dead
15822 BLACK CRAFT Till Death
15825 BLACK CRAFT Eternal - Tarot Card
15827 BLACK CRAFT Within A Dream - Tank Top
15828 BLACK CRAFT Levitate
15829 BLACK CRAFT Precious Blood
15909 BLACK CRAFT Create Your Own Future - Tarot Card
15913 BLACK CRAFT One Nation No God
15915 BLACK CRAFT Unholy 666
15920 BLACK CRAFT Reality
15922 BLACK CRAFT Protection Moth
15923 BLACK CRAFT Within A Dream
15924 BLACK CRAFT Death Card
16560 REBEL8 METAL 8 NECKLACE GOLD
16561 REBEL8 METAL 8 NECKLACE SILVER
16564 REBEL8 WOMENS GREY LOGO BOYFRIEND TEE
16574 REBEL8 WOMENS KILLA KOLLAGE TEE
16579 REBEL8 WOMENS BACKLOT CROP TEE
16583 REBEL8 EARRINGS GOLD
16584 REBEL8 EARRINGS SILVER
17541 DEAD END THREADS Foxdie Black(B)
17979 REBEL8 BACK TO THE BEACH BLACK TANK
18013 REBEL8 FREEDOM BLACK TANK
18014 REBEL8 FREEDOM GREY TANK
20029 BLACK CRAFT ALL YOU NEED
20156 REBEL8 GIANT FLASH VELCRO WALLET
20160 REBEL8 SUDS BELT
20236 PARADOX - BASIC TEE (MIST)
20237 PARADOX - BASIC TEE (MOONSIDE)
20238 PARADOX - BASIC TEE (MAGIC)
20239 PARADOX - BASIC TEE (SHRINE)
20240 PARADOX - BASIC TEE (HORKEW)
20241 PARADOX - BASIC TEE (CELL)
20242 PARADOX - BASIC TEE (NIGHTMARE)
20243 PARADOX - BASIC TEE (GLOW)
20244 PARADOX - BASIC TEE (PARALLEL)
20245 PARADOX - BASIC TEE (PLASTER)
20246 PARADOX - BASIC TEE (MARTIAN)
20247 PARADOX - LONG TEE (MIST)
20248 PARADOX - LONG TEE (MOONSIDE)
20249 PARADOX - LONG TEE (MAGIC)
20250 PARADOX - LONG TEE (SHRINE)
20251 PARADOX - LONG TEE (DAWN)
20252 PARADOX - LONG TEE (HORKEW)
20253 PARADOX - LONG TEE (CELL)
20254 PARADOX - LONG TEE (NIGHTMARE)
20255 PARADOX - LONG TEE (GLOW)
20256 PARADOX - LONG TEE (PARALLEL)
20257 PARADOX - LONG TEE (XTAL)
20258 PARADOX - BIG TEE (MIST)
20259 PARADOX - BIG TEE (NIGHTMARE)
20260 PARADOX - LONG TEE (PLASTER)
20261 PARADOX GRAPHIC BIG TEE MAGIC
20262 PARADOX - BIG TEE (SHRINE)
20263 PARADOX - BIG TEE (HORKEW)
20264 PARADOX - BIG TEE(GLOW)
20265 PARADOX - BIG TEE(PARALLEL)
20266 PARADOX - BIG TEE(PLASTER)
20267 PARADOX - BIG TEE(MARTIAN)
20268 PARADOX - HORKEW POACH
20269 PARADOX - TWOWAY POACH(JACKFROST)
20270 PARADOX - TWOWAY POACH(HEXA)
20288 REBEL8 USPTO NECKLACE
20292 REBEL8 DOMINEIGHT WALLET
20355 PARADOX SUPER LONG CUTSEWN NIGHTMARE
21143 BLACK CRAFT Nevermore TEE
21144 BLACK CRAFT Blackcraft TEE
21146 BLACK CRAFT Unholywood
21147 BLACK CRAFT Manifest
21149 BLACK CRAFT Crowley's Moth
21150 BLACK CRAFT Temple
21155 BLACK CRAFT Leviticus
21159 BLACK CRAFT Aquarius
21160 BLACK CRAFT Pisces