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 >= '2023-01-29 10:34:26')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
66796 NineMicrophones(ナインマイクロフォンズ) ENVELOPE MILITARY SHIRT BLACK
66797 NineMicrophones(ナインマイクロフォンズ) ENVELOPE MILITARY SHIRT KHAKI
66736 NieR (ニーア) 袖切り離し可能2WAY BLACK SHIRT ZIP OUTER
65986 【予約商品】PUNK DRUNKERS (パンクドランカーズ) ピーチポロシャツ - BLACK
63266 GALFY (ガルフィー) 東名阪チームシャツ WHITE (中日)
64970 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / COLOR
62654 PUNK DRUNKERS PDベースボールシャツ - BLUE
62653 PUNK DRUNKERS PDベースボールシャツ - BLACK
62655 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - BLACK
62656 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - D.GREEN
60886 PUNK DRUNKERS [PDSx阪神タイガース]阪神ベースボールシャツ - WHITE
65505 NieR (ニーア) HALF ZIP HOODIE
65349 SUPPLIER (サプライヤー) VENOM REFLECTOR TEE
65016 ハッピーハンバーグ レーシングチームメカニックシャツ WHITE
65006 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/Blue(ブルー)
65005 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/White×Blue(ホワイト×ブルー)
64251 TRAVAS TOKYO【トラバストーキョー】Sailor collar H/S Shirts Black
64253 TRAVAS TOKYO【トラバストーキョー】Necktie H/S Shirts Black
65145 ANIMALIA BIG SILHOUETTE POLO SHIRTS -WORK SUCKS-
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
65007 TRAVAS TOKYO【トラバストーキョー】 配色ニットポロシャツ/Black×Purple(ブラック×パープル)
64971 ROLLING CRADLE RC x KUDAN CUSTOM SHIRT / MONO
64268 RIPNDIP (リップンディップ) Aloha Nerm Short Sleeve Button Up (Black)
63709 NieR (ニーア) セットアップルームウェア【刺繍LOGO】
63813 Subciety(サブサエティ) PAISLEY COACH SHIRT BLUE
63812 Subciety(サブサエティ) PAISLEY COACH SHIRT BLACK
63819 Subciety(サブサエティ) MILITARY OVER SHIRT BLACK
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
63105 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLUE
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
62153 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLUE
62154 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT KHAKI
63884 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / YELLOW
63885 ROLLING CRADLE (ローリングクレイドル) 2TONE KUNG-FU SHIRT / BLACK
63772 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - BLACK
63771 TOY MACHINE (トイマシーン) SECT WAX EMBROIDERY BIG SHIRTS - OFF WHITE
63226 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - F.GREEN
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
62198 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - GRAYⅠ
62200 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - BURGUNDY
62212 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - WHITE
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62228 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - BLACK / DRAGONFLY
62229 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - RED / DRAGONFLY
62226 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - FLOWER
62207 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE / PAISLEY
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
63449 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS WHITE
63450 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS BLUE
63451 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS GREEN
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
16880 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - WHITE
61925 glamb (グラム) Nixon Aloha SH - Black
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
60156 Anti Social Social Club WOODY WHITE BUTTON UP
60159 Anti Social Social Club STATIC ORANGE BUTTON UP
60158 Anti Social Social Club STATIC BLACK BUTTON UP
60351 HYPER CORE O-181B Continue?ショートスリーブボタンシャツ
60131 HYPER CORE HCO-181 Cherry Frappuccino 半袖シャツ
60157 【予約商品】Anti Social Social Club WOODY BLACK BUTTON UP
58727 VIRGO VGW ALOHA SHIRTS RED
57920 Subciety (サブサエティ) WEEKENDER SHIRT - BLACK
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
59247 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLUE
59220 LONELY論理 LONELISM SHIRTS white
59221 LONELY論理 LONELISM SHIRTS black
58438 HEDWiNG Neon Totalhandle Shirt Black
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
48409 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF WHITE
8152 Subciety EMBLEM SHIRT S/S-Plain- WHITE
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
22967 Subciety EMBLEM SHIRT S/S YELLOW
22968 Subciety EMBLEM SHIRT S/S PINK
23004 Subciety ALOHA SHIRT S/S NAVY
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
23021 Subciety OMBRE CHECK SHIRT S/S-THRON- MUSTARD
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
24962 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- GREEN
24963 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- BEIGE
24964 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- WHITE
24966 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- OD
29187 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- BLUE
29188 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- YELLOW
32632 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF-WHITE
39582 Subciety MULTI CAMO SHIRT S/S
39586 Subciety CHECK SHIRT GREEN
47515 Subciety WORK SHIRT S/S-Basjoe- GRAY
47860 Subciety (サブサエティ) CHECK SHIRTS-BABYLON- RED
54747 Dezzn Savior Shirt BLACK
7511 DROP DEAD CLOTHING LEOVEPARD TOP
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
11059 VANS APPAREL RUSDEN IKAT S/S SHIRT LIVING CORAL
11062 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT RED
11097 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN WHITE
15292 REBEL8 WOMENS WATCH YOUR STEP BUTTON-UP
15758 MISHKA (ミシカ) Crypt Keeper Button Up Shirt
20011 ROLLING CRADLE FUCK×FUCK SHIRT / White
23613 Zephyren (ゼファレン) EMBLEM SHIRT S/S CAMO II
23973 ANIMALIA AN16U-SH03 BOUND PRISONER #001 GRAY
23976 ANIMALIA AN16U-SH04 SWAGGER #003 BLACK
24727 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- RED
24728 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- BLACK
24731 Zephyren (ゼファレン) CAMOUFLAGE SHIRT S/S -Charmed SQ Tone- CAMO V