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 06:16:22')
AND pc.classcategory_id1 IN( 25,1,8,117,30,133,132)
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
57795 SALUTE EVAE* X BLACKLUX NECKLACE
63293 Anti Social Social Club Kkoch Black Cap
63296 Anti Social Social Club Playboy x ASSC Bunny White Socks
63297 Anti Social Social Club Playboy x ASSC Bunny Black Socks
63300 Anti Social Social Club Down The Tube Black/White Socks
63388 Anti Social Social Club Down The Tube Blue/White Socks
63387 Anti Social Social Club Down The Tube Pink/White Socks
63302 Anti Social Social Club Collapse White Socks
63301 Anti Social Social Club Collapse Black Socks
62122 STAPLE×Hello Kitty Socks BLACK
61638 STAPLE×Sesame Street Tote Bag
60144 Anti Social Social Club FRACTURE BLACK
60145 Anti Social Social Club FRACTURE PINK
55640 【予約商品】Anti Social Social Club WEIRD CAP BLACK
59839 Evae mob *EVAE+Tyga Collaboration Necklace
59840 Evae mob *EVAE+Tyga Collaboration Bracelet
56215 Anti Social Social Club Headrush Cap
57406 SALUTE Cactus flower flame necklace
55645 Anti Social Social Club BROKEN ANKLE WHITE SOCKS
50649 CHORD NUMBER EIGHT CHA1-01K5-AC09 CROSS NECKLACE
57812 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×WHITE
57813 PARADOX SELECTABLE LAYERED T-SHIRTS BLACK×BURGUNDY
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
55893 SALUTE FLOWER ANARCHY BRACELET
55892 SALUTE FLOWER ANARCHY NECKLACE
56216 Anti Social Social Club Belong 2 You Black Sidebag
56217 Anti Social Social Club See Right Thru Me Pink Belt
56218 Anti Social Social Club See Right Thru Me Black Belt
56219 Anti Social Social Club 7734
56220 Anti Social Social Club Sadness Is Happiness
56221 Anti Social Social Club My Bad Side Pink
56222 Anti Social Social Club My Bad Side Black
55985 PARADOX ZIP BUCKET HAT
55641 Anti Social Social Club ASHTON BLACK CAP
55642 Anti Social Social Club SOCAL WHITE SOCKS
55643 Anti Social Social Club SOCAL BLACK SOCKS
55644 Anti Social Social Club BROKEN ANKLE BLACK SOCKS
55531 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) LIGHT PURPLE
54594 PARADOX PX17-CS03 BIG WIDE TEE BLACK
54947 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) BLACK
54946 PARADOX PX17-BT01 GRAPHIC BIG T-SHIRTS(NEVER SATISFIED) WHITE
54950 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) GLAY
54949 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) BLACK
54948 PARADOX PX17-BT02 GRAPHIC BIG T-SHIRTS(STAY DIFFERENT) WHITE
54596 PARADOX PX17-CS03 BIG WIDE TEE PURPLE
9054 REBEL8 ALPINE RUST BEANIE
9056 REBEL8 ALPINE GREY BEANIE
9745 REBEL8 ALPINE MAROON BEANIE
11117 REBEL8 STANDARD ISSUE LOGO SNAPBACK
11119 REBEL8 STANDARD ISSUE CANVAS WALLET
11121 REBEL8 RUN TO THE HILLS SOCKS BLK/WHT
11122 REBEL8 WHITE LOGO SOCKS
11123 REBEL8 MUERTOS SOCKS
11124 REBEL8 BLACK LOGO SOCKS
11127 REBEL8 LEATHER LOGO LIGHTER CASE
11128 REBEL8 RUBBER LOGO KEYCHAIN
11316 BLACK CRAFT Blackcraft Beanie
13723 REBEL8 TILTED 8 LOGO SOCKS BLK
13725 REBEL8 CHARCOAL LOGO SOCKS
13726 REBEL8 NAVY/KHAKI LOGO SOCKS
13731 REBEL8 LEATHER WALLET
13732 REBEL8 STANDARD ISSUE LEATHER WALLET
13734 REBEL8 FALL STICKER PACK
13742 REBEL8 SCHOLARS SNAPBACK
13745 REBEL8 S.I. LOGO W UNDERBRIM SNAPBACK BLACK
14629 REBEL8 ZEUS BELT
14855 REBEL8 WHITE/MAROON LOGO SOCKS
14856 REBEL8 BLACK/YELLOW LOGO SOCKS
15079 REBEL8 YELLOW POM BEANIE
15080 REBEL8 JOIN OR DIE GREY POM BEANIE
15083 REBEL8 WATCH YOUR STEP GREY BEANIE
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シャツ
15558 FAR★STAR BLOOD目苺
15559 FAR★STAR 六芒星 BIG T WHT
15562 FAR★STAR 目リップ BIG T RED
15563 FAR★STAR 目リップ BIG T BLK
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
15934 BLACK CRAFT Believe In Yourself - Snapback Hat
15935 BLACK CRAFT Unholy - Snapback Hat
15936 BLACK CRAFT One Nation No God - Snapback Hat
16560 REBEL8 METAL 8 NECKLACE GOLD
16561 REBEL8 METAL 8 NECKLACE SILVER
16569 REBEL8 GIANT FLASH BACKPACK
16575 REBEL8 BONES BLACK SOCKS
16583 REBEL8 EARRINGS GOLD
16584 REBEL8 EARRINGS SILVER
16829 REBEL8 ALPINE RUST BEANIESPRING LOGO SNAPBACK
17596 REBEL8 SPRING NEON LOGO SNAPBACK CAP BLACK
17992 FAR★STAR 悪魔.jp
17996 FAR★STAR CHAIN BIG 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
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
20247 PARADOX - LONG TEE (MIST)
20248 PARADOX - LONG TEE (MOONSIDE)
20249 PARADOX - LONG TEE (MAGIC)
20250 PARADOX - LONG TEE (SHRINE)