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-05-04 14:17:49')
AND pc.stock > 0
AND pc.point_rate >1
AND pc.classcategory_id1 IN( 12,44)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
59304 Subciety (サブサエティ) CROWD S/S BLACK
63341 Subciety (サブサエティ) BLACK PANTHER TEE BLACK
64003 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-BROWN
64004 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-KHAKI
35644 MARILYN MANSON SMELLS LIKE T-SHIRTS
64306 RIPNDIP (リップンディップ) Lord Nermal Pocket Tee (Black)
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
64002 VIRGOwearworks (ヴァルゴウェアワークス)BAMBI CHECK PANTS BLACK-BLACK
57279 Subciety (サブサエティ) PARKA-PROVIDENCE- NAVY
58323 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT PINK
58324 THRASHER (スラッシャー) TH8128 GONZ T-SHIRT YELLOW
65102 【glamb (グラム)GB0422/CS11 : Fake Layered Wide CS / フェイクレイヤードワイドカットソー - Gray
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
63234 TOY MACHINE (トイマシーン) AXEL SS TEE - PURPLE
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
61777 MISHKA (ミシカ) M21100512 JACKET
61401 NineMicrophones PIGMENT PARKA BLACK
61403 NineMicrophones PIGMENT PARKA GREEN
61405 NineMicrophones SWEAT-Wanderer- BLACK
63903 VIRGO(ヴァルゴ)LAYERED MID VA-1 BLACK
63926 VIRGO(ヴァルゴ)NATIVE KNIT SNAP SWT BLACK
63952 VIRGO(ヴァルゴ)PERFECTION L/S SPECIAL BLACK
63955 VIRGO(ヴァルゴ)PERFECTION L/S SPECIAL WHITE
65078 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Black×Navy
65079 glamb (グラム)GB0422/SH05 : Double Layered SH / ダブルレイヤードシャツ - Khaki×White
61832 A FEW GOOD KIDS AFGK BOWLING STADIUM JACKET PINK
65160 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY SWEAT PANTS GRAY
63517 glamb (グラム) Lips and Song Turtle Knit - Black
61988 glamb (グラム) Classic Jersey Pants - Black
58374 WASTED PARIS Worker Pants Houdstooth Brown
64941 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE WHITE
64096 SLEEPING TABLET(スリーピング・タブレット) RECIPE [ BAND COLLAR SHIRTS ] WHITE
64129 SLEEPING TABLET(スリーピング・タブレット) METEOR [ PUFF JACKET ] BLACK
64125 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ PULLOVER ] BLUE
65163 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT GREEN
65161 BAD BOY (バッドボーイ) AMECOMI LOGO JQD P/O KNIT O.WHITE
65120 glamb (グラム)GB0422/T02 : Aestheticism T / エステティシズムT - Black
64522 Zephyren(ゼファレン)COACH JACKET - FEAR NO ONE - BLACK
63989 VIRGO(ヴァルゴ)BIG HIND BLACK
63990 VIRGO(ヴァルゴ)BIG HIND WHITE
65155 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY HALFZIP SWEAT BLACK
65157 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY HALFZIP SWEAT GRAY
65152 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY SWEAT BLACK
63504 glamb (グラム) Fuzzy Leopard Cardigan - Wine
64359 DI:VISION (ディヴィジョン) FICTION LS TEE WHITE
64353 【ゲキクロ限定】DI:VISION (ディヴィジョン) FICTION TEE WHITE
64354 【ゲキクロ限定】DI:VISION (ディヴィジョン) FICTION TEE BLACK
64246 SABBAT13(サバトサーティーン) SPOOK SAFARI SHIRTS BLACK
63593 glamb (グラム) Heavy Damaged SH - Black
65009 SUPPLIER (サプライヤー) IRON LOGO RAGLAN TEE/GREEN
64939 A FEW GOOD KIDS (アフューグッドキッズ) POPULAR CARTOON TEE WHITE
64937 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE WHITE
64938 A FEW GOOD KIDS (アフューグッドキッズ) STARRY SKY LOGO TEE BLACK
64942 A FEW GOOD KIDS (アフューグッドキッズ) DATING CLUB LONG SLEEVE BLACK
64943 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE WHITE
64944 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE BLACK
64945 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE BEIGE
64946 A FEW GOOD KIDS (アフューグッドキッズ) EMBROIDERY THREE-DIMENSIONAL LOGO TEE ORANGE