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 10:20:02')
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 240, 120
14216 REBEL8 ANY MEANS BLACK TEE
14217 REBEL8 ANY MEANS WHITE TEE
14629 REBEL8 ZEUS BELT
14852 REBEL8 JOIN OR DIE WHITE TEE
14853 REBEL8 JOIN OR DIE RED TEE
14854 REBEL8 JOIN OR DIE BLACK TEE
14855 REBEL8 WHITE/MAROON LOGO SOCKS
14856 REBEL8 BLACK/YELLOW LOGO SOCKS
14857 REBEL8 JOIN OR DIE BLACK PULLOVER
15077 REBEL8 RIBBON FLOW BLACK PULLOVER
15079 REBEL8 YELLOW POM BEANIE
15080 REBEL8 JOIN OR DIE GREY POM BEANIE
15083 REBEL8 WATCH YOUR STEP GREY BEANIE
15086 REBEL8 EIGHTERS ZIP-UP HOODIE
15094 REBEL8 ODDS BADGE NAVY POCKET TEE
15283 REBEL8 WOMENS JOIN OR DIE PULLOVER
15284 REBEL8 WOMENS LOGO LOCK UP CREWNECK
15285 REBEL8 TORN TO BITS BLACK TEE
15286 REBEL8 EIGHTERS GREY TEE
15287 REBEL8 EIGHTERS BLACK TEE
15288 REBEL8 WOMENS RIBBON FLOW PULLOVER
15289 REBEL8 VNDERGROVND BLACK TEE
15291 REBEL8 WATCH YOUR STEP BLACK TEE
15292 REBEL8 WOMENS WATCH YOUR STEP BUTTON-UP
15293 REBEL8 WOMENS BANDANA 8 ZIP-UP HOODIE
15298 REBEL8 EIGHTERS GREY SOCKS
15299 REBEL8 RUN TO THE HILLS ARMY SOCKS
15302 REBEL8 VNDERGROVND SNAPBACK
15553 FAR★STAR 六芒星 BIG T BLK
15554 FAR★STAR 百目 レディース ショートTシャツ
15555 FAR★STAR 百目 ロング丈 Tシャツ
15556 FAR★STAR 百目 Tシャツ
15557 FAR★STAR 百目 ハーフパンツ
15558 FAR★STAR BLOOD目苺
15559 FAR★STAR 六芒星 BIG T WHT
15560 FAR★STAR 六芒星 パーカー WHT
15561 FAR★STAR 六芒星 パーカー BLK
15562 FAR★STAR 目リップ BIG T RED
15563 FAR★STAR 目リップ BIG T BLK
15564 FAR★STAR ツノ パーカー
15565 FAR★STAR 百目 トートバッグ
15566 FAR★STAR 目苺 BIG T
15567 FAR★STAR 目苺 ロング丈T
15568 FAR★STAR 百目 マルチネックウォーマー
15569 FAR★STAR 目苺パーカー
15572 FAR★STAR 百目 BIG WHT
15574 FAR★STAR 百目 BIG BLK
15812 BLACK CRAFT Lucipurr - Hooded Pullover Sweater
15816 BLACK CRAFT Hail Satan And Drink Coffee Crewneck
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
15934 BLACK CRAFT Believe In Yourself - Snapback Hat
15935 BLACK CRAFT Unholy - Snapback Hat
15936 BLACK CRAFT One Nation No God - Snapback Hat
16367 BLACK CRAFT Baphomet 666 - Hooded Pullover Sweater
16560 REBEL8 METAL 8 NECKLACE GOLD
16561 REBEL8 METAL 8 NECKLACE SILVER
16564 REBEL8 WOMENS GREY LOGO BOYFRIEND TEE
16568 REBEL8 WOMENS HI-RISE INDIGO JEAN
16569 REBEL8 GIANT FLASH BACKPACK
16573 REBEL8 LOGO COLLAGE BLACK TEE
16574 REBEL8 WOMENS KILLA KOLLAGE TEE
16575 REBEL8 BONES BLACK SOCKS
16578 REBEL8 BACKLOT BLACK TEE
16579 REBEL8 WOMENS BACKLOT CROP TEE
16583 REBEL8 EARRINGS GOLD
16584 REBEL8 EARRINGS SILVER
16826 REBEL8 CROSSBONES COACHES JACKET
16829 REBEL8 ALPINE RUST BEANIESPRING LOGO SNAPBACK
16831 REBEL8 DEATH SQUAD WHITE TEE
16870 REBEL8 1995 BLACK TEE
16872 REBEL8 FEELS GOOD BLACK TEE
16873 REBEL8 CROSSBONES BLACK TEE
16874 REBEL8 ALPINE RUST BEANIEPOCALYPSE BLACK TEE
16875 REBEL8 APOCALYPSE BURGUNDY TEE
16876 REBEL8 FRIED BLACK GLOW IN THE DARK TEE
16878 REBEL8 FRIED ROYAL GLOW IN THE DARK TEE
17541 DEAD END THREADS Foxdie Black(B)
17596 REBEL8 SPRING NEON LOGO SNAPBACK CAP BLACK
17979 REBEL8 BACK TO THE BEACH BLACK TANK
17986 REBEL8 BUILDING BLACK TEE
17987 REBEL8 BUILDING WHITE TEE
17988 REBEL8 RULERS BLACK TEE
17992 FAR★STAR 悪魔.jp
17994 REBEL8 FREEDOM WHITE TEE
17995 REBEL8 FREEDOM BLACK TEE
17996 FAR★STAR CHAIN BIG Tee
17998 REBEL8 SMOKING HAND BLACK TEE
17999 REBEL8 SMOKING HAND TIE-DYE TEE
18002 FAR★STAR チェーンスター ZIPパーカー
18003 FAR★STAR 六芒星 BIG T 黒目
18004 FAR★STAR 六Bone星 パーカー
18005 FAR★STAR 六Bone星 BIG T WHT
18006 FAR★STAR 六Bone星 BIG T BLK
18007 REBEL8 ON THE RUN BLACK TEE
18011 REBEL8 ALPINE RUST BEANIEMADE AND PAID GREY TEE
18013 REBEL8 FREEDOM BLACK TANK
18014 REBEL8 FREEDOM GREY TANK
20029 BLACK CRAFT ALL YOU NEED
20153 REBEL8 STEALTH WHITE SOCKS WHITE
20154 REBEL8 STEALTH WHITE SOCKS BLACK
20155 REBEL8 GIANT FLASH LAPTOP SLEEVE
20156 REBEL8 GIANT FLASH VELCRO WALLET
20157 REBEL8 LEATHER LOGO KEYCHAIN
20158 REBEL8 METAL 8 KEYCHAIN GOLD
20159 REBEL8 METAL 8 KEYCHAIN SILVER
20160 REBEL8 SUDS BELT
20161 REBEL8 CALIFORNIA ORIGINALS BANDANA
20189 REBEL8 EIGHTH OMEN GREY HEATHER