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-23 23:42:44')
AND pc.classcategory_id1 IN( 11)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02)
LIMIT 0, 240
55869 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts White
57994 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Black
60393 GoneR GR30LS001 Tattoo Flash L/S T-Shirts Black
57388 FILA FS3027 L/S T-Shirt WHITE
57429 THRASHER (スラッシャー) TH93130 FLAME LOGO L/S T-SHIRT WHITE
58026 TOY MACHINE ED MONSTER PRINT LONG TEE - BLACK
58147 RIP DESIGN WORXX Rest in Punk ロングスリーブTシャツ WHITE
58148 RIP DESIGN WORXX Rest in Punk ロングスリーブTシャツ SAND BEIGE
55853 GoneR × 大内慶 Collaboration L/S T-Shirts Forest
60301 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - WHITE
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
62784 GoneR GR32LS002 Fire Pattern L/S T-Sirts Purple
60612 SABBAT13 CONSPIRACY L/S T WHITE
60688 DI:VISION ENVIOUS LS TEE BLACK
60689 DI:VISION ENVIOUS LS TEE L-BLUE
57108 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE WHITE
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
60603 RIPNDIP Lord Nermal Pocket Long Sleeve (Light Lime)
60605 RIPNDIP Lord Nermal Pocket Long Sleeve (Dusty Rose)
55904 MISHKA x Johnny Ryan DON'T LET THEM L/S T-SHIRTS BLUE
58334 RUDIE'S (ルーディーズ) DRAWING LS-T BLACK
58572 MISHKA(ミシカ) SPOOKY CREW LONGSLEEVE PURPLE
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
62528 KILL STAR Dark Forces Long Sleeve Top
62940 RUDIE'S (ルーディーズ) HELLO LS-T BLACK
53083 KAVANE Clothing "ERR"Long Sleeve(Blk)
63698 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Gray
63701 AFFECTER (アフェクター) CHAOS L/S Tee Black
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
56515 ANIMALIA AN20A-TE06 “SWAGGER CLOTHINGS Poster” L/S TEE WHITE
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
57394 FILA FS3020 L/S T-Shirt CHARCOAL
57091 RUDIE'S (ルーディーズ) RUDIE'S x BYRD / LOOK SLICK LS-T BLACK
57092 RUDIE'S (ルーディーズ) RUDIE'S x BYRD / LOOK SLICK LS-T WHITE
59019 Nine Microphones EMERGE L/S - BLACK
59079 Subciety (サブサエティ) Separation L/S - WHITE
59081 Subciety (サブサエティ) Separation L/S - GRAY
59231 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLUE×ORANGE
60653 Subciety (サブサエティ) BUBBLE L/S BLUE
53062 RIP DESIGN WORXX RIPDW ツーフェイスSkulown L/S Tシャツ GRAY
61204 XrossOver XOver K logo LongT (Black)
55863 GoneR GR26LS001 Rough Rose L/S T-Shirts Dark chocolate
55864 GoneR GR26LS001 Rough Rose L/S T-Shirts Black
55865 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts White
55867 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Dark chocolate
55870 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts Forest
56425 Subciety (サブサエティ) SERVER L/S - BLACK
56426 Subciety (サブサエティ) SERVER L/S - LIME
56427 Subciety (サブサエティ) VANDALIZE L/S - WHITE
56507 STAPLE×Hello Kitty Logos L/S Tee BLACK
59599 Zephyren(ゼファレン) L/S TEE - twilight - WHITE
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
61471 NineMicrophones Description L/S WHITE
63235 acOlaSia (アコレイジア) Hungry L/S WHITE
60379 輪入道×GALFY×GEKIROCK CLOTHING スペシャル・コラボ・ロンT BLACK
60704 ROLLING CRADLE LOGO ROSE LONG SLEEVE / PINK
58097 WASTED PARIS T-shirt LongsleeveNebula Black
58098 WASTED PARIS T-shirt LongsleeveNebula White
58027 TOY MACHINE OG MONSTER PRINT LONG TEE - WHITE
55852 GoneR × 大内慶 Collaboration L/S T-Shirts White
58005 GoneR GR28LS003 Bleach Cactus Flower L/S T-Shirts Black
61562 TOY MACHINE (トイマシーン) TURTLE HEAD LONG TEE - WHITE
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
65339 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-WHITE
65388 TOY MACHINE (トイマシーン) MONSTER MARKED LONG TEE-INDIGO BLUE
56832 Subcietyx攻殻機動隊 TACHIKOMA L/S TEE SHIRT WHITE
56835 Subcietyx攻殻機動隊 TACHIKOMA L/S TEE SHIRT BLUE
56841 Subcietyx攻殻機動隊 Cyberbrain L/S WHITE
58454 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S BLACK
61240 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション NIRVASH L/S WHITE
61241 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション EUREKA L/S BLACK
67441 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE WHITE
56150 MAGICAL MOSH MISFITS MxMxM FLAME LONG TEE WHITE
55908 MISHKA MAW200002 L/S T-SHIRTS SAFTY GREEN
56780 KEYTALK×GEKIROCK CLOTHING 限定コラボ・ロンT BLACK
57364 MISHKA M21000001 L/S T-Shirt BLACK
60496 Subciety (サブサエティ) SUEDE SWITCHED L/S WHITE
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
62887 PSYCHOLOGICAL METAMORPHOSIS PLMP×Gurin. LS TEE 03 - WHITE
56478 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・ロンT WHITE
56479 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・ロンT ORANGE
57198 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE BLUE
62788 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts White
62789 GoneR (ゴナー) GR32LS003 Tie-dye One Point Logo L/S T-Sirts Purple
22239 Xmas Eileen ラグランTシャツ
22768 Xmas Eileen バックプリントロングTシャツ
23842 TRUST RECORDS NUMBER 84 LONG T
27811 Crossfaith GLITCH ON BLACK LONGSLEEVE SHIRT
27816 Crossfaith Longsleeve Shirt(2016Spring)
37840 Xmas Eileen DIS IS LOVEロングスリーブTシャツ
63176 DI:VISION (ディヴィジョン) WYRM LS TEE WHITE
65682 SABBAT13(サバトサーティーン) SCAPEGOAT L/S T BLACK
41066 OBEY x Misfits Fiend Club Custom Box Pigment LS Tee BLACK
55947 TOY MACHINE FIST EMBROIDERY LONG TEE - WHITE
60296 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - WHITE
61563 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - BLACK
61565 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - GREEN
53938 そこに鳴る ねこぎっしりロンT
56171 HEDWiNG HD-012 Pierrot Mask Longsleeve T-shirt Purple
58333 RUDIE'S (ルーディーズ) DRAWING LS-T WHITE
58337 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T BLACK
60051 SAMURAI CORE サイコLS TEE BLACK
60053 SAMURAI CORE コラージュLS TEE BLACK
60357 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO BEIGE
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 / 邪悪なる猫の君主
23815 ENTH LOGO LONGSLEEVE TEE WHITE
23816 ENTH LOGO LONGSLEEVE TEE BLACK
23817 ENTH LOGO LONGSLEEVE TEE RED
23818 ENTH LOGO LONGSLEEVE TEE GREEN
64433 PUNK DRUNKERS [PDSx高須クリニック]YES!高須クリニックロンTEE - BEIGE
61741 東京13零式 (トウキョウイチサンゼロシキ) T-Shirt 狗吠 Smoky Purple
50609 PassCode BOX LOGO LONG SLEEVE SHIRT
56048 KAVANE Clothing×DADAROMA 朋 "SAVE MYSELF"LONG SLEEVE(Wht)
31737 Xmas Eileen ONLY THE BEGINNING ロングスリーブTシャツ
36502 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve White
36503 【ゲキクロ限定】 a crowd of rebellion Gingerol Longsleeve Black
58024 TOY MACHINE TOYMONSTER HELLO KITTY EMBROIDERY LONG TEE - WHITE
60040 HEDWiNG Right or wrong Longsleeve T-shirt White
62537 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - WHITE
61216 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO KENNY LONG TEE - WHITE
61218 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - WHITE
57995 GoneR GR28LS002 Rose Arrange Skull L/S T-Shirts White
57128 SABBAT13 SPOOK INSIDE L/S T BLUE
57133 SABBAT13 HIDE&SEEK L/S T WHITE
62132 ROLLING CRADLE SMILE LONG SLEEVE WHITE
57395 FILA FS3020 L/S T-Shirt BLACK
26526 Hi-STANDARD NINJA L/S TEE
37126 KEYTALK LONG SLEEVE T-SHIRT BKACK
37127 KEYTALK LONG SLEEVE T-SHIRT WHITE
39254 ヒステリックパニック ロングスリーブT ホワイト
39255 ヒステリックパニック ロングスリーブT ブラック
41758 Survive Said The Prophet SURVIVE LONG TEE
42640 KEYTALK ロングスリーブ Tシャツver.2 ライム
42641 KEYTALK ロングスリーブ Tシャツver.2 ブルー
46177 Survive Said The Prophet NE:ONE TOUR LONG TEE
58488 SILLENT FROM ME FILLM -Loose Long Sleeve- BLACK
59018 Nine Microphones EMERGE L/S - WHITE
59230 PSYCHOLOGICAL METAMORPHOSIS DYED 2TONE LS TEE BLACK×RED
62786 GoneR GR32LS002 Fire Pattern L/S T-Sirts Black/Red
63836 アマツカミ 棘文字 L/S T-shirts
63837 アマツカミ 棘/Thorn L/S T-shirts
64360 DI:VISION (ディヴィジョン) FICTION LS TEE CHACOAL
65795 アマツカミ 藤/wisteria L/S T-shirts
60543 ROLLING CRADLE COSPLAY GIRL-MOON- LONG SLEEVE / WHITE
35287 SLIPKNOT Fashion Tee Logo Star
67442 TOY MACHINE (トイマシーン) FLAME FIST LONG TEE BLACK
34061 【ゲキクロ限定】 PassCode x ヴィレッジヴァンガード × 激ロック 『bite the bullet』 LIMITED LONGSLEEVE TEE
61132 Subciety (サブサエティ) SABBAT13 × Subciety L/S BLACK
61133 Subciety (サブサエティ) SABBAT13 × Subciety L/S WHITE
65381 Subciety (サブサエティ) G.I SIGN L/S BLACK
35561 BRING ME THE HORIZON Sempiternal Long Sleeve
35606 FIVE FINGER DEATH PUNCH ZOMBIE KILL LONG SLEEVE TEE
63699 AFFECTER (アフェクター) AFE COLLEGE LOGO L/S Tee Black
63700 AFFECTER (アフェクター) CHAOS L/S Tee Orange
69498 NieR (ニーア) UVカット×吸汗速乾ドライシルキータッチカットソー【FACE LOGO】
60422 GALFY (ガルフィー) わんわん大学ロンTee T.GRAY
28024 WAGE WAR LONG T
35286 SLIPKNOT Long Sleeved Tee: Blocks
46178 Survive Said The Prophet ENGLISH LONG TEE
47827 Survive Said The Prophet S P A C E [ S ] TOUR LONG TEE (TOYA VER.)
47828 Survive Said The Prophet S P A C E [ S ] TOUR LONG TEE (KAWADO VER.)
49716 Survive Said The Prophet 47 TOUR LONG TEE
51184 【ゲキクロ限定】 This is LAST×ゲキクロ コラボロンT BLACK
54621 Survive Said The Prophet PROPHET L/S TEE
54623 Survive Said The Prophet OLD ENGLISH L/S TEE
58433 Survive Said The Prophet MIXED LOGO L/S TEE GRAY
58434 Survive Said The Prophet MIXED LOGO L/S TEE BLACK
59603 Zephyren(ゼファレン) BIG L/S TEE - jua - WHITE
62541 over print (オーバープリント) SHADOWS LS Tee (navy)
62542 over print (オーバープリント) SHADOWS LS Tee (black)
62543 over print (オーバープリント) SHADOWS LS Tee (ivory)
62544 over print (オーバープリント) SHADOWS LS Tee (moca)
62545 over print (オーバープリント) SHADOWS LS Tee (dark green)
62546 over print (オーバープリント) SHADOWS LS Tee (blue)
62569 Survive Said The Prophet NEW STANDARD L/S TEE SAFETY YELLOW
65165 Subciety (サブサエティ) NOVEL GLORIOUS TEE-GRAY/BLACK
65167 Subciety (サブサエティ) NOVEL GLORIOUS TEE-BLACK/KHAKI
65170 Subciety (サブサエティ) NOVEL GLORIOUS TEE-WHITE/GREEN
61564 TOY MACHINE (トイマシーン) OG MONSTER EMBROIDERY LONG TEE - WHITE
39497 【ゲキクロ限定】 PassCode 限定ロンT “LOCUS”
41070 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / RED
41071 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / GREEN
41072 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 BLACK / PURPLE
41073 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / RED
41074 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / PURPLE
41075 【ゲキクロ限定】KEYTALK × ゲキクロ スペシャル・コラボ LS Tシャツ 2018 WHITE / BLUE
26207 BEHEMOTH DEMON LONG SLEEVE
51429 GREEN DAY Unisex Long Sleeved Tee: Welcome to Paradise
59550 Zephyren(ゼファレン) JACQUARD CUT L/S WHITE
59551 Zephyren(ゼファレン) JACQUARD CUT L/S BLACK
59553 Zephyren(ゼファレン) JACQUARD CUT L/S GREEN / MIX
60356 RUDIE'S (ルーディーズ) GOOD VIBRATION LS-T GRADATION LOGO LAVENDER
65797 RUDIE'S (ルーディーズ) BRINK PHAT LS-T-WHITE
59069 Subciety (サブサエティ) RAGLAN L/S - BLACK
59071 Subciety (サブサエティ) RAGLAN L/S - BEIGE
61239 Subciety (サブサエティ)×EUREKA/交響詩篇エウレカセブン ハイエボリューション NIRVASH L/S BLACK
53063 RIP DESIGN WORXX RIPDW ツーフェイスSkulown L/S Tシャツ KHAKI
53064 RIP DESIGN WORXX RIPDW ツーフェイスSkulown L/S Tシャツ ORANGE
66481 MAGICAL MOSH MISFITS EVANGELION キン肉マン x MxMxM “ドクロビン” LONG TEE BLACK
60797 MAGICAL MOSH MISFITS EVANGELION x MxMxM “MxMxM 2号機” LONG TEE REAL
70079 洋服倶楽部シェイプス 電愛ラブストーリー L/S Tee(LIGHT BLUE)
70080 洋服倶楽部シェイプス 電愛ラブストーリー L/S Tee(WHITE)
55082 Zephyren(ゼファレン)BIG L/S TEE - VISIONARY / Kaleidoscope - BLACK
55861 GoneR GR26LS001 Rough Rose L/S T-Shirts White
55862 GoneR GR26LS001 Rough Rose L/S T-Shirts Forest
55866 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Forest
55868 GoneR GR26LS002 Messege Rose Sleeve L/S T-Shirts Black
55871 GoneR GR26LS003 Mexican Goods Skull L/S T-Shirts Dark chocolate
55872 GoneR GR26LS003 Mexican Goods Skull L/S T-ShirtsBlack
56908 Unlucky Morpheus Unfinished ロングTシャツ
57289 FOG ESSENTIALS FRONT LOGO LS TEE BLACK
57290 FOG ESSENTIALS FRONT LOGO LS TEE TAN
57291 FOG ESSENTIALS FRONT LOGO LS TEE CREAM
57365 MISHKA M21000001 L/S T-Shirt WHITE
58431 Survive Said The Prophet BITMAP L/S TEE ORANGE
58432 Survive Said The Prophet BITMAP L/S TEE WHITE
60497 Subciety (サブサエティ) SUEDE SWITCHED L/S NAVY
62623 LONELY論理 NEW LOGO LONG SLEEVE PURPLE
62624 LONELY論理 NEW LOGO LONG SLEEVE BLACK
62626 LONELY論理 LONELISM6 LONG SLEEVE SAX
62628 LONELY論理 LONELISM6 LONG SLEEVE BLACK
63156 over print (オーバープリント) plane LS Tee (white)
63157 over print (オーバープリント) plane LS Tee (heather gray)
63158 over print (オーバープリント) plane LS Tee (dark green)
63159 over print (オーバープリント) plane LS Tee (lavender)
63160 over print (オーバープリント) plane LS Tee (off pink)
63356 over print (オーバープリント) PASS name LS Tee (light gray)
63357 over print (オーバープリント) PASS name LS Tee (blue)
63358 over print (オーバープリント) PASS name LS Tee (chacoal)