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-24 13:56:48')
AND pc.price02 > 2727
AND price02 <= 4545
AND pc.stock > 0
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
56555 Subciety A.V.E.S.T TEE -ROCKIN IN THE COFFIN-BGN
56570 ICECREAM IC13H255 Beanie RED
56573 SO SO HAPPY Be My Monster Puff Girls T-Shirt
9643 ICECREAM RACING DOG S/S T-SHIRT PURPLE
9644 SLIP&Co. BAMBINX TEE BLACK
12162 SPITFIRE MASSACRE S/S Tee BLACK
14880 SO SO HAPPY You Make Me Melt
14988 Agape Attire SON OF THE MOST HIGH TEE
15171 フクザワ 知らん女の自撮りTシャツ
15886 フクザワ 飼われ男 Tシャツ
18103 KILL STAR CLOTHING HORNY T-SHIRT [B]
18831 KILL STAR CLOTHING PIZZA ORDER MUSCLE TANK [B]
20169 FUZZ REZ ZWEEP DELAY TEE BLK
20170 FUZZ REZ ZWEEP DELAY TEE WHT
20337 AGAPE ATTIRE Militello Script Ringer Tee
20339 AGAPE ATTIRE CLASSIC SCRIPT TANK
21083 フクザワ あの日のこと Tシャツ
21159 BLACK CRAFT Aquarius
23685 SPITFIRE Malt Bighead Black
23779 KILL STAR CLOTHING (キルスター・クロージング) Earthlings Earrings [S]
24123 ANIMALIA AN16U-AC13 CONCHO RING #001 NATURAL
27389 THRASHER 16TH-C26 WASH CAP WHITE
27515 KILL STAR CLOTHING (キルスター・クロージング) In My Mind Tank [B]
27735 ANIMALIA AN16A-AC12 Cigarette Pouch RED
28047 SPITFIRE Bighead Fill T-Shirt - Black/Red
28143 KILL STAR CLOTHING (キルスター・クロージング) People Tank [B]
28155 KILL STAR CLOTHING (キルスター・クロージング) Poison Tank [B]
28235 SRH TRIBE WOMENS TEE BLACK
28349 フクザワ 白昼夢 Tシャツ
36284 HOLDTUBE HT-0172 REGULAR GO CAMP
36971 フクザワ 【まったり】 Tシャツ
39905 SANTA CRUZ Classic Dot S/S T-Shirt White
39908 SANTA CRUZ Classic Dot S/S T-Shirt Silver
41142 HOLDTUBE ANS1706 SACOSH ORIJINAL DENIM
42988 RUDIE'S SPARK iQOS PROTECTOR BLACK/WHITE
42989 RUDIE'S PHAT iQOS PROTECTOR BLUE RED
39529 KILL STAR CLOTHING Nikky Choker [B]
54839 RIP DESIGN WORXX ライジングロゴアーミーTシャツ SAND
54837 RIP DESIGN WORXX ライジングロゴアーミーTシャツ WHITE
55679 RIP DESIGN WORXX アンノウンクラウンTシャツ BLACK
55558 PSYCHOLOGICAL METAMORPHOSIS EXPANSION SS TEE RED
36701 RUDIE'S (ルーディーズ) SPARK GALAXY iQOS PROTECTOR
56192 RIP DESIGN WORXX オートグラフイヤーカフ
56899 Anti Social Social Club ICE RINK
56901 Anti Social Social Club SAFE AND SOUND PINK (LUGGAUGE STRAP)
56902 Anti Social Social Club SAFE AND SOUND BLACK (LUGGAUGE STRAP)
57191 acOlaSia SMILE MOON BEANIE ORANGE
57384 FILA FS3028 T-Shirt WHITE
57385 FILA FS3028 T-Shirt NAVY
58021 THRASHER (スラッシャー) TH91292 T-Shirt GREEN
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
58509 THRASHER (スラッシャー) TH8101 MAG LOGO S/S TEE KHARKI/BLACK
58673 KILL STAR CLOTHING Bad Faith Earrings
58675 KILL STAR CLOTHING Chiroptera Earrings
58677 KILL STAR CLOTHING Ave Satana Earrings
58851 NieR (ニーア) オフショルベルト CUTSEW
58513 DESURABBITS × ゲキクロ × KAVANE Clothing 限定コラボ・Tシャツ
55646 Anti Social Social Club MEDICAL MASK
59311 Anti Social Social Club Sweet And Sour Rainbow Mask
59308 PSYCHOLOGICAL METAMORPHOSIS INVERSION LOGO TEE ORANGE
59368 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE BLACK
59366 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE RED
59367 PSYCHOLOGICAL METAMORPHOSIS DIAGONAL TEE GREEN
59867 PSYCHOLOGICAL METAMORPHOSIS NOT TEE BLACK
58726 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Black
58724 GoneR -La Neta- GRL04CT002 LUZ Y SOL T-Shirts Light Purple
59297 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Gardenal Red
59295 GoneR GR29CTW001 GoneR × PICTURE MOUSE Collavoration T-Shirts Pistachio
58719 GoneR -La Neta- GRL04CT001 Mexican Flag T-Shirts Light Purple
58698 GoneR GR29CT002 Square Mexican Skull T-Shirts Stone Blue
60084 NieR (ニーア) GRAPHIC CUTSEW【きぐるみミケ】
60197 Anti Social Social Club VVS Yellow Mask
60208 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Partners Tシャツ
60207 すばらしきこのせかいThe Animation×ARTIMATION Shibuya Battle Tシャツ
58938 Subciety (サブサエティ) LOW WATCH CAP - PINK
59724 Zephyren(ゼファレン) LONG BEANIE -You Are Here ORANGE
59723 Zephyren(ゼファレン) LONG BEANIE -You Are Here PURPLE
59717 Zephyren(ゼファレン) LONG BEANIE -You Are Here WHITE
60618 SABBAT13 PARADISE LOST TOTE BAG BEIGE
60641 RIPNDIP Scribble Face Mask (Green)
60700 RUDIE'S (ルーディーズ) BLANK KNITCAP NEON GREEN
60875 RUDIE'S (ルーディーズ) SLICK GLOVE NEON GREEN
60876 RUDIE'S (ルーディーズ) SLICK GLOVE NEON ORANGE
61604 HYPER CORE VACCINATEDニーハイ
61605 HYPER CORE BOOSTニーハイ
61606 HYPER CORE GRUDGEニーハイ
61607 HYPER CORE MUMMYディザイアニーハイ
61608 HYPER CORE ピザイアニーハイ
61632 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP GREEN
61631 PSYCHOLOGICAL METAMORPHOSIS OLD FUTERE CAP BLACK
62992 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 折りたたみ傘
62999 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類代表参鋒 佐々木小次郎 "二天流" TEE
62997 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類代表次鋒 アダム "拳骨主義" TEE
62995 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 人類先鋒 呂布奉先 "否" TEE
62994 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ 神代表先鋒 トール "雷槌" TEE
62993 EXTRA NICHE DESIGN(エクストラニーシュデザイン)× 終末のワルキューレ ブリュンヒルデ「ビビってるんですか?」TEE
63407 Meltyglow (メルティグロウ) Melty総柄デザイン CUTSEW
62117 ROLLING CRADLE Mjolnir TEE / BLACK
63440 BAD BOY (バッドボーイ) 00'S GRAPHIC EMBROIDERY TEE WHITE
63443 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE WHITE
63444 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE BLACK
63445 BAD BOY (バッドボーイ) RAINBOW EMBROIDERY TEE L.BLUE
63446 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee WHITE
63447 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee BLACK
63448 BAD BOY (バッドボーイ) FIREPATTERN LOGO PRINT Tee L.BLUE
63449 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS WHITE
63318 GoneR (ゴナー) GR33TK001 Rose Maria Tank-Top Black
63674 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - WHITE
63676 TOY MACHINE (トイマシーン) OG MONSTER SS TEE - BLACK
63197 ANIMALIA (アニマリア) Double Cutaway - logo BLACK
63195 ANIMALIA (アニマリア) TANK TOP - logo BLACK
63196 ANIMALIA (アニマリア) TANK TOP - logo WHITE
63193 ANIMALIA (アニマリア) HOODIE Tee S/S - logo BLACK
63825 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE BLACK
63822 BAD BOY (バッドボーイ) U.S.A LOGO EMBROIDERY TEE WHITE
63820 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE BLACK
63818 BAD BOY (バッドボーイ) TEAM LOGO EMBROIDERY TEE WHITE
63350 ROLLING CRADLE (ローリングクレイドル) CYCLOPS TOY PACKAGE TEE / SAND
64078 AFFECTER (アフェクター) COLLEGE LOGO CAP BLACK
64077 AFFECTER (アフェクター) COLLEGE LOGO CAP GRAY