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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =6
)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-05-27 02:16:29')
AND ( p.sales_end_datetime IS NULL AND p.deliv_date_id != 9 )
AND pc.price03 IS NOT NULL
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
52984 VIRGO VG-SH-215 NOSTALGIC CHECK TOP BLACK
55633 Anti Social Social Club FRANTIC WHITE FLANNEL
55632 Anti Social Social Club FRANTIC RED FLANNEL
54998 Zephyren(ゼファレン)LONG SHIRT L/S PAINT
55012 Zephyren(ゼファレン)BIG SHIRT L/S - As above,So below - RED
56116 SILLENT FROM ME CULTISM Long Length Shirts WHT
55401 VIRGO ROCKET LONG SHIRTS - BLACK
56198 NOT COMMON SENSE REBUILDING BREACH SHIRT
56561 CIVARIZE【シヴァーライズ】 ZIP付きロングシャツ BLACK
56563 CIVARIZE【シヴァーライズ】 ZIP付きロングシャツ WHITE
56857 ANIMALIA AN20A-SH01 “OUTSIDER SHIRTS” BLACK CHECK
55917 MISHKA MAW200210 SHIRTS
56892 SALUTE DESERT SHIRT
56894 SALUTE RACING PRINTER SHIRT
55969 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLACK
55970 ANIMALIA AN20A-SH02 “R.I.B. SHIRTS” BLUE
58108 MISHKA M21000251 SHIRT
57123 SABBAT13 BLACK HEART CHECK SHIRTS BEIGE
58311 ROLLING CRADLE BIG CHECK SHIRT / BLACK
58303 SLEEPING TABLET FLIP [ FRAYED HEM LOOSE SHIRTS ] PINK
57006 VIRGO Relaxed uniform shirts BLACK
57004 VIRGO Relaxed uniform shirts BEIGE
58341 SILLENT FROM ME CHEAP -Band collar Shirts- BLACK
58340 SILLENT FROM ME CHEAP -Band collar Shirts- WHITE
55403 VIRGO ROCKET LONG SHIRTS - WHITE
58599 SLEEPING TABLET REVERIE NOBLE [ SILKY PAJAMA SHIRTS ] LAVENDER
58593 SLEEPING TABLET REVERIE [ PATTERNED PAJAMA SHIRTS ] NAVY
58839 NieR (ニーア) STYLISH BLACK Y-SHIRT
59846 HYPER CORE SICKS BEAR 2WAYワークシャツ
60225 NieR (ニーア) スクール風ブラックシャツ【ネクタイ付き】
60227 NieR (ニーア) ボウタイ付き シフォンブラウス【BLACK】
59507 Zephyren(ゼファレン) SHIRT L/S - Resolve - BLACK / PAISLEY
60455 ROLLING CRADLE CHECK NELSHIRT / BLUE
60454 ROLLING CRADLE CHECK NELSHIRT / YELLOW
58598 SLEEPING TABLET REVERIE NOBLE [ SILKY PAJAMA SHIRTS ] GLAY
58597 SLEEPING TABLET REVERIE NOBLE [ SILKY PAJAMA SHIRTS ] BLACK
60545 ROLLING CRADLE HOOD CHECK SHIRT / YELLOW
60365 GoneR GR30SH001 Tattoo Flash Chambray Shirts Chambray
58975 Subciety (サブサエティ) WESTERN SHIRT - BLACK/GRAY
58977 Subciety (サブサエティ) WESTERN SHIRT - NAVY/SILVER
58981 Subciety (サブサエティ) COVER ALL SHIRT - WHITE
58985 Subciety (サブサエティ) COVER ALL SHIRT - BLACK
59500 Zephyren(ゼファレン) LONG SHIRT L/S - Resolve - FLOWER
59535 Zephyren(ゼファレン) BIG SHIRT L/S NAVY / PAISLEY
59536 Zephyren(ゼファレン) BIG SHIRT L/S DRAGONFLY
59537 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S BLACK / GREEN
59538 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S YELLOW / BLACK
59539 Zephyren(ゼファレン) SWITCHING BIG SHIRT L/S MIX
61145 SABBAT13 SPOOK CHECK SHIRTS PURPLE
61144 SABBAT13 SPOOK CHECK SHIRTS GREEN
60155 Anti Social Social Club BORED GAMES BROWN FLANNEL
60153 Anti Social Social Club BORED GAMES PURPLE FLANNEL
61507 CIVARIZE【シヴァーライズ】フラワードルマンジャガードシャツ Purple
60290 MISHKA M61000209 L/S SHIRT
61808 CIVARIZE【シヴァーライズ】 オーバーミリタリーシャツ B
57011 VIRGO Middle Cuban shirt WHITE
61514 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxWHITE
61513 ANIMALIA AN22SP-SH01 CHAMBRAY SHIRTS - A.C. Brand DENIMxBLACK
61087 VIRGO MIXTURE LONG SHIRTS KHAKI
62115 ROLLING CRADLE SKAJAN JERSEY / GREEN