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 =97
)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-30 21:09:48')
AND pc.stock > 0
AND p.product_id IN (
SELECT product_id FROM `dtb_product_categories`
WHERE category_id IN (
SELECT category_id FROM `dtb_category` WHERE `parent_category_id` = 10
)
)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date
LIMIT 0, 60
20751 Subciety BASEBALL TEE 7/S-COLLEGE- GRAY
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
39558 PARADOX ORACLE L/S TEE (YELLOW)
46250 SABBAT13 SBT-LT-020 13X-BONE L/S T (ブラック)
46263 SABBAT13 SBT-LT-022 D.D.T.W L/S T(ブラック)
46274 SABBAT13 SBT-LT-023 G.F.G L/S T(ゴールド)
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
53068 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE WHITE
55960 火寺企画 完全無敵のロングスリーブTシャツ BLACK
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
56195 NOT COMMON SENSE BRAIN LAYERED L/S TEE WHITE
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
56047 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Blk)
56049 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(ゲキクロ限定カラー)
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
56517 水野ギイ×RIPDW×GEKIROCK CLOTHINGコラボ・ロンT PURPLE
56839 Subcietyx攻殻機動隊 Cyberbrain L/S PURPLE
56757 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツBLACK/RED
56755 エルフリーデ×ゲキクロ×DI:VISION限定ロング・スリーブTシャツ WHITE/BLACK
56424 Subciety (サブサエティ) SERVER L/S - WHITE
57389 FILA FS3027 L/S T-Shirt NAVY
57811 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×MINT
58092 WASTED PARIS T-shirt Longsleeve Columbia Bridge Yellow
57312 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt White
58160 NOT COMMON SENSE FLAME L/S TEE BLACK
58161 NOT COMMON SENSE FLAME L/S TEE WHITE
58285 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW BLACK
58286 ANIMALIA AN21S-CS02 Calamity Jane L/S - SKUNK PAW WHITE
57991 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Sand
58851 NieR (ニーア) オフショルベルト CUTSEW
58456 Subciety×NARUTO-ナルト- 疾風伝 KAKASHI&GUY L/S BLACK
58453 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S WHITE
60331 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE BLACK
60330 LONELY論理 KAZAGURUMA HEARTS LONG SLEEVE WHITE
60418 MUSIC SAVED MY LIFE (MSML) ROSE LONG SLEEVE TEE WHITE
59162 VIRGO TY MOCK NECK WHITE
60652 Subciety (サブサエティ) BUBBLE L/S BLACK
61057 NieR (ニーア) ミケLONGSLEEVE CUTSEW
61059 NieR (ニーア) logo LONGSLEEVE CUTSEW
61205 XrossOver XOver K logo LongT (White)
61472 NineMicrophones Description L/S BLACK
60524 うみくん×GEKIROCK CLOTHING×KAVANE Clothingコラボ・ロンT
52490 【バンドリ!×ゲキクロ 第4弾復刻】DI:VISION×若宮 イヴ コラボ 限定 L/S Tシャツ
61559 PSYCHOLOGICAL METAMORPHOSIS MOCK NECK HEAVY TEE BLACK
20366 THRASHER (スラッシャー) TH8301 MAG LOGO L/S T-SHIRT WHT
28486 THRASHER (スラッシャー) TH8301 MAG LOGO LONG TEE BLK/WHT
61848 A FEW GOOD KIDS DRIP CIRCLE LOGO LONG SLEEVE WHITE
61851 A FEW GOOD KIDS DRIP CIRCLE LOGO LONG SLEEVE BLACK
61483 glamb (グラム) Cactus Print Raglan CS GREEN
61482 glamb (グラム) Cactus Print Raglan CS BLACK
62608 HYPER CORE SICKS MUTE BEARロングスリーブTシャツ WHITE
61711 HEDWiNG College logo C/C Longsleeve T-shirt White
61713 HEDWiNG One stroke owl Longsleeve T-shirt Mustard
62625 LONELY論理 LONELISM6 LONG SLEEVE WHITE
62629 LONELY論理 OROCHI TAIJI LONG SLEEVE WHITE
62627 LONELY論理 LONELISM6 LONG SLEEVE PINK
61365 SLEEPING TABLET (スリーピングタブレット) ORDER [ LONG SLEEVE ] BLACK
62588 ROLLING CRADLE BURNED LOGO LONG SLEEVE / BLACK