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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)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-04-20 12:58:31')
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
63295 Anti Social Social Club Playboy x ASSC Bunny Logo White Hoodie
63294 Anti Social Social Club Playboy x ASSC Bunny Logo Black Hoodie
63298 Anti Social Social Club ASSC x retaW Black Hoodie
62118 STAPLE×Hello Kitty Friends Hoodie BLACK
62119 STAPLE×Hello Kitty Friends Hoodie GRAY
61635 STAPLE×Sesame Street Crew Hoodie
61636 STAPLE×Sesame Street Oscar Hoodie
60160 Anti Social Social Club THE REAL ME BLACK HOODIE
60162 Anti Social Social Club I SEE PINK SPLASH BLACK HOODIE
60161 Anti Social Social Club I SEE BLUE SPLASH BLACK HOODIE
57407 FOG ESSENTIALS Riflector Logo Hoodie PINK
56485 SALUTE Flower Anarchy Hoodie BLACK
56484 SALUTE Flower Anarchy Hoodie BLUE
56895 SALUTE CACTUS PRINTER HOODIE
57071 SALUTE WASHED TARGET HOODIES
45119 FOG ESSENTIALS Pullover Hoodie BLACK
45120 FOG ESSENTIALS Pullover Hoodie B/CREAM
50552 FOG ESSENTIALS Pullover Hoodie LIGHT HEATHER
56766 FOG ESSENTIALS Solid Hoodie TAN
56765 FOG ESSENTIALS Solid Hoodie L/H.GRY
56202 Anti Social Social Club True Colors Purple Camo
56203 Anti Social Social Club Birdbath Black Hoodie
56204 Anti Social Social Club Headrush All Over White Hoodie
56205 Anti Social Social Club Don’T Black Hoodie
56206 Anti Social Social Club Don’t Red Hoodie
56207 Anti Social Social Club Sweeter Then You Think Black Hoodie
56110 N.B.O. FLOWER PATCH SWEATER KHAKI
55630 Anti Social Social Club BAT EMOJI WHITE HOODIE
55627 Anti Social Social Club THE GROVE BLACK HOODIE
55628 Anti Social Social Club SAMSIES BLUE HOODIE
55629 Anti Social Social Club SAMSIES PINK HOODIE
55635 Anti Social Social Club MIND GAMES BLACK HOODIE
55638 Anti Social Social Club TONE DEAF RED HOODIE
55639 Anti Social Social Club TONE DEF SAND HOODIE
54744 Dezzn Oversized Hooded T-Shirt Black
54745 Dezzn Oversized Hooded T-Shirt Beige
11131 REBEL8 STANDARD ISSUE LOGO PULLOVER
11268 BLACK CRAFT Lone Wolf Hooded Pullover Sweater
11765 REBEL8 FIGHT THE POWER BLACK PULLOVER
15077 REBEL8 RIBBON FLOW BLACK PULLOVER
15283 REBEL8 WOMENS JOIN OR DIE PULLOVER
15288 REBEL8 WOMENS RIBBON FLOW PULLOVER
15812 BLACK CRAFT Lucipurr - Hooded Pullover Sweater
16367 BLACK CRAFT Baphomet 666 - Hooded Pullover Sweater
20189 REBEL8 EIGHTH OMEN GREY HEATHER
20344 REBEL8 GUILLOCHE HOODIE
21163 BLACK CRAFT Planchette - White Hooded Pullover
22065 REBEL8 NIGHT WATCH HOODIE
22081 REBEL8 WOMENS NIGHT WATCH PULLOVER HOODIE
22919 REBEL8 PROPERTY OF PULLOVER HOODIE
28890 REBEL8 STANDING STRONG PULLOVER HOODIE
29887 REBEL8 TWO FACED PULLOVER BLACK HOODIE
29888 REBEL8 DEATH ZAP PULLOVER NAVY HOODIE
32357 REBEL8 EIGHT OR DIE PULLOVER HOODIE
33455 REBEL8 IMMORTAL CHAMPION HOODIE FOREST GREEN
33456 REBEL8 IMMORTAL CHAMPION HOODIE BLACK
33458 REBEL8 IMMORTALS HOODIE BLACK
33459 REBEL8 IMMORTALS HOODIE WHITE
33465 REBEL8 IMMORTALS PULLOVER TIE-DYE
33498 REBEL8 BOTTLED VIOLENCE PULLOVER HOODIE
33598 REBEL8 BREWED AND SCREWED PULLOVER HOODIE
36235 REBEL8 World War Tour Pullover
37582 REBEL8 Antagonist Pullover
37711 DOGTOWN 2SWZDOCLOG DT CROSS LOGO ZIP HOOD
37729 REBEL8 Foretold Pullover Hoodie
37752 REBEL8 Foretold Pullover
37755 REBEL8 Slashed Pullover
37756 REBEL8 Lodi Dodi Hooded Polo
37815 REBEL8 Sacrifice Pullover
38644 REBEL8 Blotch Pullover
38646 REBEL8 Stigma Pullover
38667 REBEL8 Scriptum Pullover
38680 REBEL8 Stigma Pullover
39203 REBEL8 Head Over Wheels Pullover
39260 FAR★STAR 門番モンキーパーカー
39262 FAR★STAR ペンタグラム 桜 パーカー
39264 FAR★STAR 目苺プルオーバー
39266 FAR★STAR 毒パーカー
39289 REBEL8 DEFILER PULLOVER
39520 FAR★STAR 六bone星 パーカー
39521 FAR★STAR 六芒星 パーカー
39523 FAR★STAR xxxRABIT パーカー
39866 REBEL8 Nomad Pullover
40851 REBEL8 111010037 HARD WAY PULLOVER HOODY WHT
41060 OBEY x Misfits Legacy of Phenome Pullover Hood BLACK
41061 OBEY x Misfits Legacy of Phenome Pullover Hood GREEN
41062 OBEY x Misfits Legacy of Phenome Pullover Hood WHITE
41063 OBEY The OBEY Fiend Club Pullover Hood PINK
41064 OBEY The OBEY Fiend Club Pullover Hood BLACK
41065 OBEY The OBEY Fiend Club Pullover Hood GRAY
41877 REBEL8 FORTITUDE PULLOVER HOODIE MILITARY
41879 REBEL8 FORTITUDE PULLOVER HOODIE CREAM
41880 REBEL8 FORTITUDE PULLOVER HOODIE BLACK
42828 BLACK CRAFT Believe In Yourself Bleach Wash Hooded Pullover
42834 BLACK CRAFT In Reason Unisex Lightweight Hoodie
42835 BLACK CRAFT Leviathan
42836 BLACK CRAFT Hell Cat
42837 BLACK CRAFT Fiend Pigment Dyed
42892 REBEL8 EIGHTH PULLOVER HOODIE SAND
42893 REBEL8 EIGHTH PULLOVER HOODIE BLACK
42894 REBEL8 EIGHTH PULLOVER HOODIE MAROON
42895 REBEL8 PERISHED PULLOVER HOODIE BLACK
43808 REBEL8 CRYSTAL PULLOVER HOODIE MUL
43810 REBEL8 VANILLA SKY PULLOVER HOODIE MUL
43811 REBEL8 LOVING MEMORY PULLOVER HOODIE WHITE
44100 REBEL8 Eternal Logo Pullover Black
44101 REBEL8 Eternal Logo Pullover Red
44102 REBEL8 Eternal Logo Pullover Athletic Heather
44103 REBEL8 Roach Pullover Black
44105 REBEL8 Externo Pullover Black
45166 FAR★STAR デスバナナパーカー
45595 FAR★STAR×OMEGA BIGシルエットパーカー BLACK
45779 FAR★STAR 藁人形 単体 パーカー
45961 KONUS K-49440 Pullover Hoodie w/ Acid Wash Black
50451 SALUTE MASK ZIPPER HOODIES BLACKxRED
50452 SALUTE MASK ZIPPER HOODIES BLACKxYELLOW
50713 REBEL8 LORDS II PULLOVER HOODIE BLACK
51348 CHORD NUMBER EIGHT CH01-01K5-CL54 BOA HOODIE BLACK
52495 SALUTE REMADE HOODIE
52496 SALUTE DOUBLE LAYER HOODIE