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 =571
)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 06:06:56')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
53239 【予約商品】Zephyren(ゼファレン)SWITCHING SHIRT S/S WHITE / RED
25266 DOCAN! ANARCHY workshirt
51605 MUSIC SAVED MY LIFE M101-02L1-SS02 CRAZY PATTERN SHIRT BLACK
53959 KONUS Color Blocked Cotton Twill Oversized Shirt BLACK
54205 TOY MACHINE PYRAMID SECT PRINT SS SHIRT - YELLOW
54611 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG BLACK
54612 ANIMALIA AN20U-SH01 SWAGGER-DEATH SONG WHITE
39586 Subciety CHECK SHIRT GREEN
39582 Subciety MULTI CAMO SHIRT S/S
32632 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF-WHITE
29188 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- YELLOW
29187 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- BLUE
24966 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- OD
24964 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- WHITE
24963 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- BEIGE
24962 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- GREEN
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
23021 Subciety OMBRE CHECK SHIRT S/S-THRON- MUSTARD
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
23004 Subciety ALOHA SHIRT S/S NAVY
22968 Subciety EMBLEM SHIRT S/S PINK
22967 Subciety EMBLEM SHIRT S/S YELLOW
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
60131 HYPER CORE HCO-181 Cherry Frappuccino 半袖シャツ
60159 Anti Social Social Club STATIC ORANGE BUTTON UP
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
16880 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - WHITE
63449 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS WHITE
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62198 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - GRAYⅠ
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
64268 RIPNDIP (リップンディップ) Aloha Nerm Short Sleeve Button Up (Black)
65007 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/Black×Purple(ブラック×パープル)
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
65145 ANIMALIA BIG SILHOUETTE POLO SHIRTS -WORK SUCKS-
65016 ハッピーハンバーグ レーシングチームメカニックシャツ WHITE
65349 SUPPLIER (サプライヤー) VENOM REFLECTOR TEE
65505 NieR (ニーア) HALF ZIP HOODIE
66797 NineMicrophones(ナインマイクロフォンズ) ENVELOPE MILITARY SHIRT KHAKI
68143 GoneR(ゴナー) GR36SH002 Rose Shirts Black
68137 GoneR(ゴナー) GR36SH001 Mexican Skull Shirts Black
68256 BAD BOY (バッドボーイ) FRAME JQD KNIT SHIRT BLACK
68258 BAD BOY (バッドボーイ) FRAME JQD KNIT SHIRT BLUE
68257 BAD BOY (バッドボーイ) FRAME JQD KNIT SHIRT WHITE
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
67959 ANIMALIA (アニマリア) SWAGGER S/S SHIRTS - SKUNK BLACK
68399 ANIMALIA (アニマリア) BIG SILHOUETTE S/S RUGBY SHIRTS BLACKxWHITE