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 20:18:05')
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 p.update_date
LIMIT 0, 120
22095 FUZZ REZ ZWEEP DELAY LONG SLEEVE TEE BLK
50231 Drug Honey クリスタル線画x写実的臓器プリントビッグプルオーバー RED
50232 Drug Honey クリスタル線画x写実的臓器プリントビッグプルオーバー YELLOW
52517 TRAVAS TOKYO Armed Hedgehog2 L/S Tee BLACK
52520 RUDIE’S 2020 NEWYEAR PACK
52933 TOY MACHINE TMP20LT19 L/S T-Shirt BLACK
52977 SILLENT FROM ME CRYPTIC -Extra Wide Poncho- BLACK/WHITE
52978 SILLENT FROM ME CRYPTIC -Extra Wide Poncho- BLACK/BLACK
53005 DI:VISION 7TH HEAVEN LS TEE BLACKxRED
53006 DI:VISION 7TH HEAVEN LS TEE BLACKxWHITE
53007 DI:VISION XXXX LS TEE BLACK
53059 【ゲキクロ限定】GoneR GR24LS001 Barbed Wire Rose L/S T-Shirts BLACK/PURPLE
53061 RIP DESIGN WORXX RIPDW トリックアイキャット L/S Tシャツ
53066 RIP DESIGN WORXX RIPDW アイコンシルエット L/S Tシャツ BLACK
53069 SAMURAI CORE 地震ー雷ー火事ーオヤジ LONG TEE BLACK
53072 ガリュウホンポ 子トレーナー 黒×赤
53101 PUNK DRUNKERS PDS×仮面ライダー]滅亡迅雷.net ロンTEE BLACK
53104 PUNK DRUNKERS あいつピエロンTEE BLACK
53117 LILWHITE(dot) LW-20SS-CS01 STICKY BORDER LS TEE
53169 RIP DESIGN WORXX ブラサードロングスリーブTシャツ BLACK
53896 PARADOX PX17-LS01 FAKE LAYERED L/S TEE [metaphor] WHITE
53897 PARADOX PX17-LS02 FAKE LAYERED L/S TEE [NOBLE DISEASE] BLACK
53948 NOT COMMON SENSE ”ANCIENT” L/S TEE BLACK
53949 NOT COMMON SENSE ”SWAG” L/S TEE BLACK
54053 FILA FM9787 L/S TEE BLACK
54060 FILA F9835 L/S TEE BLACK
54062 PUNK DRUNKERS [PDSxくっきー!]歯ポケロンTEE - BLACK
54070 SILLENT FROM ME TRAGEDY -Long Sleeve- BLACK
54100 PSYCHOLOGICAL METAMORPHOSIS EXPANTION L/S TEE BLACK
54129 acOlaSia ENCHANT MARROW INSTILL L/S
54130 acOlaSia PIZZA MAD L/S BLACK
55303 NieR (ニーア) BLACK LONG CUTSEW【DECO】
54184 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S BLACK
55711 RIPNDIP Besties L/S (Black Mineral Wash)
54579 アマツカミ 蛇薔薇/Rose Snake Long T-Shirts Black
54583 アマツカミ 棘薔薇 Long T-shirt Black
54587 アマツカミ 闇/Dark Long T-Shirts Black
55948 TOY MACHINE MONSTER MARKED EMBROIDERY LONG TEE - BLACK
55946 TOY MACHINE FIST EMBROIDERY LONG TEE - BLACK
55960 火寺企画 完全無敵のロングスリーブTシャツ BLACK
55907 MISHKA MAW200002 L/S T-SHIRTS BLACK
55909 MISHKA MAW200003 L/S T-SHIRTS BLACK
55992 ROLLING CRADLE MENEKI-NEKO LONG SLEEVE / PEPPER
54304 Subciety FIVE LIGHTS L/S BLACK
55665 DI:VISION UMBRELLA LS TEE BLACK
55667 ゲキクロ限定 DI:VISION UMBRELLA LS TEE YELLOW
55663 DI:VISION SHELTER LS TEE BLACK
55864 GoneR GR26LS001 Rough Rose L/S T-Shirts Black
55986 SILLENT FROM ME 沈黙・不穏 -Loose Long Sleeve- BLACK
55540 HEDWiNG Garment Dyed Longsleeve T-shirt Sumi
55538 HEDWiNG “JYOCHO” Crosscut Longsleeve T-shirt Black
55598 SABBAT13 GHOSTLY L/S T ブラック
55868 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Black
55855 GoneR × 大内慶 Collaboration L/S T-Shirts Black
54862 PUNK DRUNKERS [PDSxTHUNDERBOX]NOW TOKYOロンTEE - BLACK
56095 RUDIE'S GUESTPASS LS-T BLACK
54325 Subciety Purgatory L/S BLACK
55435 VIRGO LOABT LST - BLACK
56152 MAGICAL MOSH MISFITS MxMxM FLAME LONG TEE BLACK
55078 Zephyren(ゼファレン)L/S TEE - fiat lux - BLACK
54585 アマツカミ 花 L/S BLACK
56156 MUSIC SAVED MY LIFE (MSML) BANDANA LONG SLEEVE SLIT CUTSEW BLACK
56157 MUSIC SAVED MY LIFE (MSML) COTTON MESH LONG SLEEVE SLIT CUTSEW BLACK
56160 MUSIC SAVED MY LIFE (MSML) BOX LOGO LONG SLEEVE TEE BLACK
56162 MUSIC SAVED MY LIFE (MSML) MSML GRAPHIC LONG SLEEVE TEE BLACK
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
56194 NOT COMMON SENSE BRAIN LAYERED L/S TEE BLACK
55023 Zephyren(ゼファレン)DOLMAN BIG TEE L/S - Kaleidoscope - BLACK
56012 アマツカミ 「永眠」Long T-shirts Purple
56011 アマツカミ 「永眠」Long T-shirts White
56010 アマツカミ 「絶望感」Long T-shirts Purple
56009 アマツカミ 「絶望感」Long T-shirts White
54857 PUNK DRUNKERS [PDSxPAC-MAN]逃げロンTEE - BLACK
56290 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (BLACK)
56507 STAPLE×Hello Kitty Logos L/S Tee BLACK
56544 NieR (ニーア) ラグラン袖LONG CUTSEW
56543 【ゲキクロ限定】PSYCHOLOGICAL METAMORPHOSIS PLMP MULTI LS TEE
56558 CIVARIZE フラワー総柄ドレープロンT Black×Purple
56562 CIVARIZE フラワー総柄ドレープロンT Black
56790 GALFY 神YABAI Tee BLACK
56602 acOlaSia HOMINIDAE L/S BLACK
56604 acOlaSia INSANE L/S BLACK
56099 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.A BLK/RED
56100 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.A BLK/WHT
56102 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.B BLK/RED
56103 TRiDENT×DI:VISION×GEKIROCK CLOTHING SPECIALコラボロンT TYPE.B BLK/WHT
56133 アマツカミ 紫薔薇/Violet Rose L/S T-shirts
56134 アマツカミ 髑髏/Skull L/S T-shirts
56135 アマツカミ 神代/Gods L/S T-shirts
56136 アマツカミ 苑/Place L/S T-shirts
56137 アマツカミ 金魚/Goldfish L/S T-shirts
56173 そこに鳴る×アマツカミ×GEKIEOCK CLOTHINGコラボ・ロンT第2弾
56047 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Blk)
56049 【ゲキクロ限定】KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(ゲキクロ限定カラー)
56770 FOG ESSENTIALS RIFLECTOR LOGO LS TEE BLACK
56496 DI:VISION SALVAGE LS TEE BLACK
55791 【バンドリ!×ゲキクロ 第2弾復刻】MISHKA×牛込りみコラボ 限定 L/S Tシャツ
56516 水野ギイ×RIPDW×GEKIROCK CLOTHINGコラボ・ロンT BLACK
56957 MAGICAL MOSH MISFITS x SONIC THE HEDGEHOG“MAGICAL SONIC MISFITS” LONG TEE RED
56959 MAGICAL MOSH MISFITS x SONIC THE HEDGEHOG“MAGICAL SONIC MISFITS” LONG TEE BLUE
56250 KAVANE Clothing "DAZE"Long Sleeve
57080 NieR (ニーア) 総柄LONG CUTSEW
57081 NieR (ニーア) 総柄LONGTEE【NieR CATCHER】
57091 RUDIE'S (ルーディーズ) RUDIE'S x BYRD / LOOK SLICK LS-T BLACK
57109 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE BLACK
57111 TOY MACHINE SECT STAFF GRADATION LONG TEE BLACK
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
56494 DI:VISION HE-X-EN LS TEE BLACK
57185 acOlaSia 煙仄 L/S BLACK
56831 Subcietyx攻殻機動隊 Cyberbrain L/S TEE SHIRT BLACK
56838 Subcietyx攻殻機動隊 TACHIKOMA L/S TEE SHIRT BLACK
57254 ガリュウホンポ 猫ロングTシャツ
57256 ガリュウホンポ 金魚ラグラン
57257 ガリュウホンポ マスクロングTシャツ
56586 GALFY 犬っていいかもTee 漆黒
56912 RUDIE'S 2021 NEW YEAR PACK
57284 MISHKA FLAMING KEEP WATCH LS TEE
57285 MISHKA 2 CHILL 4 DEATH LS TEE BLACK
57287 MISHKA STACKED LS TEE BLACK