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-05-26 19:50:35')
AND FIND_IN_SET(1, p.color)
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 MAX(price02)
LIMIT 0, 60
63330 Meltyglow (メルティグロウ) Melty刺繍デザインBLACK CUTSEW
57994 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Black
60393 GoneR GR30LS001 Tattoo Flash L/S T-Shirts Black
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
60688 DI:VISION ENVIOUS LS TEE BLACK
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
61555 NieR (ニーア) ワイド袖口カットソー
58334 RUDIE'S (ルーディーズ) DRAWING LS-T BLACK
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
62528 KILL STAR Dark Forces Long Sleeve Top
62940 RUDIE'S (ルーディーズ) HELLO LS-T BLACK
63701 AFFECTER (アフェクター) CHAOS L/S Tee Black
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
57301 HEDWiNG “W”ave Longsleeve T-shit Black
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
57126 SABBAT13 SPOOK INSIDE L/S T BLACK
61390 ANIMALIA ANKN-TE05 UKIYOE - Hurricane mixer L/S BLACK
61391 ANIMALIA ANKN-TE08 10M Powers L/S BLACK
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
57091 RUDIE'S (ルーディーズ) RUDIE'S x BYRD / LOOK SLICK LS-T BLACK
59019 Nine Microphones EMERGE L/S - BLACK
60748 HYPER CORE L-130 DID YOU GET THE VACCINE?ロングスリーブTシャツ 黒
60743 ガリュウホンポ 丑ロングTシャツ
61204 XrossOver XOver K logo LongT (Black)
58500 ガリュウホンポ ビッグロゴロングTシャツ
55864 GoneR GR26LS001 Rough Rose L/S T-Shirts Black
56425 Subciety (サブサエティ) SERVER L/S - BLACK
56507 STAPLE×Hello Kitty Logos L/S Tee BLACK
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
60379 輪入道×GALFY×GEKIROCK CLOTHING スペシャル・コラボ・ロンT BLACK
60659 CIVARIZE【シヴァーライズ】バイカラードッキングシャツ White×Black
57311 【ゲキクロ限定】 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt Black
58097 WASTED PARIS T-shirt LongsleeveNebula Black
58005 GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Black
62781 GoneR GR32LS001 Wall decoration L/S T-Sirts Black/White
62787 GoneR GR32LS002 Fire Pattern L/S T-Sirts Black/Purple
58454 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S BLACK
61241 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション EUREKA L/S BLACK
57364 MISHKA M21000001 L/S T-Shirt BLACK
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
65682 SABBAT13(サバトサーティーン) SCAPEGOAT L/S T BLACK
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
58337 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T BLACK
60051 SAMURAI CORE サイコLS TEE BLACK
60053 SAMURAI CORE コラージュLS TEE BLACK
60359 RUDIE'S (ルーディーズ) PHAT LS-T BLACK
62171 KILL STAR Deimos Long Sleeve Top
62941 RUDIE'S (ルーディーズ) SAFARI PHAT LS-T BLACK
62942 RUDIE'S (ルーディーズ) VITAMIN PHAT LS-T BLACK
63660 Gluttonous Slaughter The MONARCH OF UNHOLY CAT Long Sleeve / 邪悪なる猫の君主
57255 ガリュウホンポ 子猫ロングTシャツ
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
57810 PARADOX SELECTABLE LAYERED T-SHIRTS WHITE×BLACK
58803 HYPER CORE SAUSE ロングスリーブTシャツ BLACK×GREEN
64118 SLEEPING TABLET(スリーピング・タブレット) DOODLE [ LONG SLEEVE ] BLACK
57395 FILA FS3020 L/S T-Shirt BLACK
56162 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE BLACK
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK