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-28 22:21:47')
AND pc.price02 > 909
AND price02 <= 2727
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 60
67441 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE WHITE
60743 ガリュウホンポ 丑ロングTシャツ
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
60379 輪入道×GALFY×GEKIROCK CLOTHING スペシャル・コラボ・ロンT BLACK
62887 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 03 - WHITE
65388 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-INDIGO BLUE
65339 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-WHITE
63698 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Gray
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
63701 AFFECTER (アフェクター) CHAOS L/S Tee Black
60688 DI:VISION ENVIOUS LS TEE BLACK
60689 DI:VISION ENVIOUS LS TEE L-BLUE
62784 GoneR GR32LS002 Fire Pattern L/S T-Sirts Purple
62778 GoneR GR32LS001 Wall decoration L/S T-Sirts White
62781 GoneR GR32LS001 Wall decoration L/S T-Sirts Black/White
62787 GoneR GR32LS002 Fire Pattern L/S T-Sirts Black/Purple
56780 KEYTALK×GEKIROCK CLOTHING 限定コラボ・ロンT BLACK
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
63330 Meltyglow (メルティグロウ) Melty刺繍デザインBLACK CUTSEW
63235 acOlaSia (アコレイジア) Hungry L/S WHITE
62940 RUDIE'S (ルーディーズ) HELLO LS-T BLACK
62528 KILL STAR Dark Forces Long Sleeve Top
61562 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - WHITE
61555 NieR (ニーア) ワイド袖口カットソー
61471 NineMicrophones Description L/S WHITE
61240 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション NIRVASH L/S WHITE
61241 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション EUREKA L/S BLACK
61391 ANIMALIA ANKN-TE08 10M Powers L/S BLACK
61390 ANIMALIA ANKN-TE05 UKIYOE - Hurricane mixer L/S BLACK
60653 Subciety (サブサエティ) BUBBLE L/S BLUE
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
55867 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Dark chocolate
55870 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts Forest
61204 XrossOver XOver K logo LongT (Black)
60748 HYPER CORE L-130 DID YOU GET THE VACCINE?ロングスリーブTシャツ 黒
60755 HYPER CORE L-131 VACCINATEDロングスリーブTシャツ 紫
60704 ROLLING CRADLE LOGO ROSE LONG SLEEVE / PINK
60659 CIVARIZE【シヴァーライズ】バイカラードッキングシャツ White×Black
60605 RIPNDIP Lord Nermal Pocket Long Sleeve (Dusty Rose)
60603 RIPNDIP Lord Nermal Pocket Long Sleeve (Light Lime)
60612 SABBAT13 CONSPIRACY L/S T WHITE
60393 GoneR GR30LS001 Tattoo Flash L/S T-Shirts Black
60496 Subciety (サブサエティ) SUEDE SWITCHED L/S WHITE
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
59019 Nine Microphones EMERGE L/S - BLACK
59599 Zephyren(ゼファレン) L/S TEE - twilight - WHITE
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
60301 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - WHITE
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
60232 NieR (ニーア) STYLISH BORDER OFF- SHOULDER【指穴付き】
59079 Subciety (サブサエティ) Separation L/S - WHITE
59081 Subciety (サブサエティ) Separation L/S - GRAY
59231 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLUE×ORANGE
58454 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S BLACK
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58500 ガリュウホンポ ビッグロゴロングTシャツ
58005 GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Black
58334 RUDIE'S (ルーディーズ) DRAWING LS-T BLACK