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-30 20:05:29')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 4680, 120
52509 BILLIE EILISH UNISEX TEE BLACK RACER LOGO (SLEEVE PRINT)
52510 BILLIE EILISH UNISEX TEE GRAFFITI WHITE
52511 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) LIME GREEN
52512 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) ORANGE
52513 BILLIE EILISH UNISEX TEE AGONY BLACK
52607 GoneR -La Neta- Chemical Wash Denim Jacket INDIGO
52608 GoneR -La Neta- One Wash Denim Jacket BLACK
52645 GoneR × LESSTRESS GR24ACW001 GoneR × LESSTRESS Key Holder White
52864 BILLIE EILISH UNISEX LONG SLEEVED TEE: SMILE (BACK & ARM PRINT) BLUE
52865 BILLIE EILISH UNISEX LONG SLEEVED TEE: MANINMAN BLUE
52866 BILLIE EILISH UNISEX TEE AGONY WHITE
52867 BILLIE EILISH UNISEX TEE RACER LOGO & BLOHSH (BACK PRINT) PINK
52868 BILLIE EILISH UNISEX TEE GRAFFITI BLACK
52869 BILLIE EILISH UNISEX TEE: BLING BLACK
52870 BILLIE EILISH UNISEX TEE: BLING WHITE
52871 BILLIE EILISH UNISEX TEE: PLEASE YOU
52898 ANIMALIA AN20SP-CP01 '49Cap-LOGO WHITE x EMERALD
52906 ROLLING CRADLE COMBI VEST / YELLOW
52915 FILA × STAPLE FM9880 WHITE
52928 RAGE AGAINST THE MACHINE UNISEX TEE: MOTOTOV (BACK PRINT)
52985 VIRGO VG-SH-215 NOSTALGIC CHECK TOP RED
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
53074 SAMURAI CORE 釈迦 HOODIE BLACK
53075 SAMURAI CORE 釈迦 HOODIE WHITE
53076 SAMURAI CORE 釈迦 HOODIE RED
53112 SAMURAI CORE 夜露死苦哀愁 HOODIE RED
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
53190 BLACK VEIL BRIDES UNISEX TEE: GRUNGE FACES
53193 OF MICE & MEN UNISEX TEE: CENTENNIAL
53194 WHILE SHE SLEEPS UNISEX TEE: MATCHES
53892 PARADOX PX17-SP-PK02 INSIDE OUT PARKA「FACE TO FACE」 BLACK
53917 PSYCHOLOGICAL METAMORPHOSIS PLMP PILE WAPPEN PARKA GREEN
53927 KEYTALK 丁寧な刺繍パーカー パープル
53928 KEYTALK 丁寧な刺繍パーカー ブラック
53930 KEYTALK 繋がるKEYTALKロゴTシャツ WHITE
53936 KEYTALK 首から下げてネックストラップ オレンジ
53944 Bentham Mobile grip
53947 NOT COMMON SENSE ”NCS FILM” HOODIE
53957 KONUS Color Blocked Oversized Short Sleeve BLACK
53958 KONUS Color Blocked Oversized Short Sleeve TEAL
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
54205 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - YELLOW
54221 ANIMALIA S/S SIDE ZIP HOODIE GRAY
54222 ANIMALIA S/S SIDE ZIP HOODIE RED
54425 【BTS着用モデル】 FILA FFM9357 T-shirts Orange
54426 【BTS着用モデル】 FILA FFM9357 T-shirts Green
54513 FILA TOKYO LABEL LOW CAP WHITE
54514 FILA TOKYO LABEL LOW CAP BLACK
54532 SAMURAI CORE SR-AC-031C 風車靴下 RED
54610 ANIMALIA AN20U-JK01 HUNTING VEST
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
54612 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG WHITE
54630 FILA FFM9836 ユニセックス クルーネックシャツ RED
54631 FILA FFM9836 ユニセックス クルーネックシャツ NAVY
54632 FILA FFM9841 ユニセックス クルーネックシャツ WHITE
54633 FILA FFM9841 ユニセックス クルーネックシャツ RED
54634 FILA FFM9841 ユニセックス クルーネックシャツ BLACK
54638 FILA FFM9847 ユニセックス クルーネックシャツ BLACK
54641 ROLLING CRADLE JUDGEMENT TEE GREEN
54673 FILA FFM9802 ユニセックス クルーネックシャツ WHITE
54674 FILA FFM9802 ユニセックス クルーネックシャツ RED
54675 FILA FFM9802 ユニセックス クルーネックシャツ NAVY
49720 Survive Said The Prophet NEW SCHOOL TEE (BLACK)
52941 Survive Said The Prophet VERTICAL LOGO TEE
54615 Survive Said The Prophet TAPED LOGO TEE WHITE
54616 Survive Said The Prophet TAPED LOGO TEE BLACK
54618 Survive Said The Prophet EMBRONDERY COMFORT TEE GREEN
54619 Survive Said The Prophet EMBRONDERY COMFORT TEE GRAY
36830 GREEN DAY American Idiot Black T-shirt
51425 GREEN DAY Unisex Tee: Drips
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
35538 BULLET FOR MY VALENTINE Temper Temper Gas Mask
52942 Survive Said The Prophet MIA TOUR TEE
52946 Survive Said The Prophet CONCRETE COACH JKT WHITE
52948 Survive Said The Prophet UNBALANCE TEE LIGHT BLUE
52949 Survive Said The Prophet UNBALANCE TEE ORANGE
52951 Survive Said The Prophet UNBALANCE TEE YELLOW
55042 Zephyren(ゼファレン)S/S TEE - VISIONARY - WHITE
52439 STAPLE Supernova Bubble Jacket
52447 STAPLE Neo Sport Nylon Crew
14277 THRASHER TH8501 MAG LOGO HOODIE BLK/WHT
46450 Zephyren(ゼファレン)BIG TANKTOP BLACK / 如意宝珠
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56570 ICECREAM IC13H255 Beanie RED
56572 NineMicrophones 9MC Crew S/S Blue
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
16679 【ゲキクロ限定カラー】lynch. ツアーTシャツ BLUE
16682 【ゲキクロ限定カラー】lynch. ツアーTシャツ GRAY
27818 Crossfaith 2016 SUMMER SILVER 5 PANEL
37046 MARILYN MANSON×KILL STAR CLOTHING Cryptorchid Harness Dress