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 dtb_products AS p
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 18:32:37')
AND pc.price02 > 909
AND price02 <= 2727
AND FIND_IN_SET(1, p.color)
AND pc.classcategory_id1 IN( 11)
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 DESC
LIMIT 0, 120
63177 THRASHER (スラッシャー) Godzilla Flame T-shirt Black
61700 Subciety (サブサエティ) BOOTLEG BRAND S/S BLACK
60292 MISHKA M61000007 T-SHIRT BLACK
60171 MISHKA X DENNIS THE MENACE TROUBLEMAKER TEE BLACK
60169 MISHKA X DENNIS THE MENACE TROUBLE MAKER LONGSLEEVE
58573 MISHKA(ミシカ) M21000005 T-Shirt
58748 MISHKA NEW WORLD ORDER LONGSLEEVE BLACK
60379 輪入道×GALFY×GEKIROCK CLOTHING スペシャル・コラボ・ロンT BLACK
62694 PUNK DRUNKERS 餅つきTEE - BLACK
62684 PUNK DRUNKERS (パンクドランカーズ) カミナリBIG.TEE - BLACK
62665 PUNK DRUNKERS[PDSxCOCALERO]八福神TEE - H.BLACK
62674 PUNK DRUNKERS (パンクドランカーズ) メニメニプリントTEE - D.H.NAVY
62678 PUNK DRUNKERS (パンクドランカーズ) サスペンダーTEE - BLACK
62691 PUNK DRUNKERS (パンクドランカーズ) アーポくんTEE - SUMI
60951 PUNK DRUNKERS [PDSxファミスタx阪神タイガース]ファミスタドランカーズTEE - BLACK
60952 PUNK DRUNKERS [PDSx太鼓の達人]太鼓マスターTEE - SUMI
60976 PUNK DRUNKERS PUNKS BAND.TEE - BLACK
60977 PUNK DRUNKERS PUNKS BAND.TEE - SUMI
62655 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - BLACK
65290 ハッピーハンバーグ ロゴプリント Tシャツ BLACH
62874 PSYCHOLOGICAL METAMORPHOSIS 4 SEASONS TEE - BLACK
65020 SABBAT13(サバトサーティーン) OUT GRAVE POCKET T (SMOKE)
62857 PSYCHOLOGICAL METAMORPHOSIS 4 TYPES TEE - BLACK
64265 RIPNDIP (リップンディップ) Summer Splash Tee (Black)
63203 Subciety (サブサエティ) DOUGH BOY TEE BLACK
63208 Subciety (サブサエティ) CAN TEE BLACK
63206 Subciety (サブサエティ) TAG S/S BLACK/ORANGE
61108 VIRGO (ヴァルゴ) NOISE S/S TEE BLACK
63212 TOY MACHINE (トイマシーン) HIROTTON COLLABO SS TEE MOHAWK - BLACK
62538 TOY MACHINE (トイマシーン) HIROTTON COLLABO LONG TEE MOHAWK - BLACK
63009 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SS TEE - BLACK
63304 GoneR (ゴナー) GR33CT001 Rose Maria T-Sirts Black
63701 AFFECTER (アフェクター) CHAOS L/S Tee Black
60688 DI:VISION ENVIOUS LS TEE BLACK
63661 Gluttonous Slaughter THE MONARCH OF UNHOLY CAT T-shirt / 邪悪なる猫の君主
62781 GoneR GR32LS001 Wall decoration L/S T-Sirts Black/White
62787 GoneR GR32LS002 Fire Pattern L/S T-Sirts Black/Purple
62133 ROLLING CRADLE SMILE LONG SLEEVE BLACK
63246 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) TOY TOY どろ~ん TEE RED
63248 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) TOY TOY どろ~ん TEE PINK
63249 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) マジカルドットキノコ TEE RED
62804 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN BENISASORITAI TEE BLACK
62808 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN LOCALFEST TEE BLACK
63184 RUDIE'S (ルーディーズ) HELLO-T BLACK
63178 THRASHER (スラッシャー) Mexico Revista T-shirt Black
61820 RUDIE'S (ルーディーズ) BRINK PHAT HOOD SWEAT BLACK
62166 RUDIE'S (ルーディーズ) COLLEGE HOOD SWEAT BLACK
62940 RUDIE'S (ルーディーズ) HELLO LS-T BLACK
63137 RUDIE'S (ルーディーズ) DONUTS PHAT-T BLACK
63094 MAGICAL MOSH MISFITS MxMxM DOKURO TEE
58609 SLEEPING TABLET SAD [ TEE ] BLACK
62266 Zephyren(ゼファレン) S/S TEE - BEYOND - BLACK
62614 NineMicrophones Chug S/S BLACK
62530 KILL STAR In A State Pull-Over Hoodie
62529 KILL STAR Bleak Hooded Cape
62169 KILL STAR Damned Hoodie
62528 KILL STAR Dark Forces Long Sleeve Top
62172 KILL STAR Deimos T-Shirt
62527 KILL STAR Blasphemia T-Shirt
61745 RIP DESIGN WORXX ハイドジップパーカー BLACK
62164 RUDIE'S (ルーディーズ) HELLO HOOD SWEAT BLACK
61524 ANIMALIA AN22SP-PT02 EASY PANTS - Sanskrit Logo BLACK
61688 TOY MACHINE (トイマシーン) FLAME FIST SWEAT HOODY NAVY
61690 TOY MACHINE (トイマシーン) EYES SWEAT HOODY BLACK
61641 THRASHER (スラッシャー) TH95166VPL GONZ STROLEING HOODIE BLACK
61585 Gluttonous Slaughter Obscurity Hoodie
61591 Gluttonous Slaughter Unique Archfiend Hoodie Black
61595 Gluttonous Slaughter DOOM Sweatshirt
61596 Gluttonous Slaughter DOOM Hoodie
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
61217 TOY MACHINE (トイマシーン) TM × SOUTHPARK COLLABO STAN LONG TEE - BLACK
60840 GoneR Ska Sweat Parka Black
61204 XrossOver XOver K logo LongT (Black)
60566 アマツカミ 棘薔薇 Rose Needle Hoodie
60340 RUDIE'S (ルーディーズ) PHAT EMBROIDERY HOOD SWEAT BLACK
60805 TOY MACHINE (トイマシーン) AMERICAN MONSTER SWEAT PARKA - BLACK
60807 TOY MACHINE (トイマシーン) TOYDIVISION SWEAT PARKA - BLACK
60268 MISHKA M61000056 T-SHIRT BLACK
60696 RUDIE'S (ルーディーズ) SCOOP PHAT HOOD SWEAT BLACK
60598 RIPNDIP Far Far Away Tee (Black/Pink/Blue Spiral Dye)
60535 TOY MACHINE (トイマシーン) FLAME FIST EMBROIDERY SWEAT CREW - BLACK
60393 GoneR GR30LS001 Tattoo Flash L/S T-Shirts Black
60498 Subciety (サブサエティ) SUEDE SWITCHED L/S BLACK
60344 RUDIE'S (ルーディーズ) SAFARI PHAT-T BLACK
59019 Nine Microphones EMERGE L/S - BLACK
59600 Zephyren(ゼファレン) L/S TEE - twilight - BLACK
60298 TOY MACHINE (トイマシーン) TOYMONSTER CAT EMBROIDERY LONG TEE - BLACK
60302 TOY MACHINE (トイマシーン) FURRY MONSTER LONG TEE - BLACK
54528 SAMURAI CORE SR-TE-004C GIVE IT こけしTEE BLACK
53145 SAMURAI CORE 地震ー雷ー火事ーオヤジ TEE BLACK
60260 RUDIE'S (ルーディーズ) SLICK BIGSILHOUETTE-T BLACK
60241 acOlaSia FRIDAY BACK PRINT TEE BLACK
60243 acOlaSia I DON'T GIVE A SHIT TEE BLACK
60254 ROLLING CRADLE OTAKU-SHOJO TEE / BLACK
59985 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA 黄緑 繭子 炎上 TEE BLACK
56997 VIRGO Off the dye BLACK
60110 Gluttonous Slaughter (グラトナス・スローター) DOOM Big T-shirt Black
60114 Gluttonous Slaughter (グラトナス・スローター) Homage for Lucifer T-shirt
60107 LONELY論理 ANTI V.A T-SHIRTS BLACK
60067 Subciety (サブサエティ) CLASSIC S/S BLACK
58695 GoneR GR29CT001 Mexican Round Design T-Shirts Black
58721 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Black
59310 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE BLACK
60029 SUPPLIER (サプライヤー) ANGEL TEE CHARCOAL
59956 NOT COMMON SENSE×目覚めの一瞬前×JUNINAGAWA chaos LOGO TEE PEPPER BLACK
57141 SABBAT13 HIDE&SEEK T BLACK
58464 NARUTO-ナルト- 疾風伝 ×Subciety SASUKE S/S BLACK
59100 PSYCHOLOGICAL METAMORPHOSIS BOX LOGO TEE BLACK
58081 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN FAMILY-T BLACK
58660 MAGICAL MOSH MISFITS おすし TEE マグロ
58661 MAGICAL MOSH MISFITS おすし TEE ドクロ
59113 MAGICAL MOSH MISFITS ポちゃんバーガー TEE REAL
59114 MAGICAL MOSH MISFITS ポちゃんバーガー TEE PINK
57484 Zephyren(ゼファレン) DOLMAN BIG TEE S/S - 冥 - BLACK
57469 Zephyren(ゼファレン) DOLMAN BIG TEE S/S BLACK / NEVER say NEVER
58454 Subciety×NARUTO-ナルト- 疾風伝 JIRAIYA L/S BLACK
59217 LONELY論理 BLUE EYEZ TEE black
58440 HEDWiNG Stripe Box T-shirt Black