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 =1
)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 18:10:37')
AND FIND_IN_SET(13, p.color)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY MAX(price02) DESC
LIMIT 0, 60
60561 Subciety 2022 福袋 -NEW YEAR BAG-
61139 RUDIE'S (ルーディーズ) 2022 福袋 -NEW YEAR BAG-
61610 RIP DESIGN WORXX 2022 カーゴパンツ福袋 BLACK
61612 RIP DESIGN WORXX 2022 カーゴパンツ福袋 PAISLEY
61272 MISHKA 2022 福袋 -NEW YEAR BAG-
58831 GALFY (ガルフィー) 炎上大学 BigTee 濃紺
63347 ROLLING CRADLE (ローリングクレイドル) HI-NECK SWEAT TEE / NAVY
67769 ROLLING CRADLE (ローリングクレイドル) OLD STYLE TEE INDIGO
58388 GALFY (ガルフィー) 半分カラーギャング BIG Tee 紺 × 朱
67565 GALFY (ガルフィー)染め染めわんちゃんボロボロ Tee NAVY
67553 GALFY (ガルフィー) 前に GAL 之 Hearts Tee B.GRAY
67560 GALFY (ガルフィー) 草野球 Tee NAVY
53142 HEDWiNG HD1-018 “Pierre” Tie-dye T-shirt Navy
71513 Subciety(サブサエティ) SCRATCHED PIGMENT TEE NAVY
63027 GALFY (ガルフィー) 炎上大学Tee 改 NAVY
59358 TRAVAS TOKYO【トラヴァストーキョー】グラフィック総柄スーパービッグTシャツ Black
54640 ROLLING CRADLE JUDGEMENT TEE NAVY
64311 Subciety (サブサエティ) LEAGUE TEE NAVY
71043 over print (オーバープリント) PIZZA PRICE Tee navy
71260 SCENE TOKYO (シーントウキョウ) game girl Tee (indigo)
71266 SCENE TOKYO (シーントウキョウ) soft cream Tee (sulate)
23125 Subciety COLLEGE S/S NAVY/WHITE
69091 SCENE TOKYO (シーントウキョウ) Skate girl Tee NAVY
69093 SCENE TOKYO (シーントウキョウ) Retro girl Tee NAVY
68469 HEDWiNG (ヘドウィグ) Shark Eat World T-Shirt SLATE BLUE
23111 Subciety SALOON S/S NAVY/YELLOW
64193 Subciety (サブサエティ) THE BASE S/S NAVY
64196 Subciety (サブサエティ) GLORIOUS S/S NAVY
53099 PUNK DRUNKERS [PDS×仮面ライダー]仮面ライダーゼロワンTEE INDIGO
69109 PUNK DRUNKERS(パンクドランカーズ)サンドウィッチTEE'23 / REVIVAL SLATE
57385 FILA FS3028 T-Shirt NAVY
24761 NORTHLANE Sphere Black w/ Orange Spider Tie Dye - T-Shirt
57305 HEDWiNG Pocket “MOJYAPON” T-shirt Navy
63183 RUDIE'S (ルーディーズ) HELLO-T NAVY
35672 FOO FIGHTERS S.F. Valley Men's T-Shirt Heather Navy
54428 【BTS着用モデル】 FILA FFM9357 T-shirts Dark Navy
20337 AGAPE ATTIRE Militello Script Ringer Tee
28396 THRASHER (スラッシャー) TH8101 MAG LOGO TEE NAV/WHT
55651 THRASHER (スラッシャー) TH8101 Mag LogoTee NAVY/SEA GREEN
59940 PUNK DRUNKERS [PDSxGreatMUTA]タッグTEE - D.H.NAVY
23749 9mm Parabellum Bullet ドットわんさかTシャツ またの名を、過剰ドットTシャツ(命名かみじょうちひろ) NVY
45956 BRING ME THE HORIZON UMBRELLA WITH BURN OUT FINISHING NAVY
28699 BLINK182 DECK
28837 アーバンギャルド 「BlueForest 」 Tシャツ
63021 GALFY (ガルフィー) とろけるわんわんTee NAVY
9313 MEMPHIS MAY FIRE Identity Navy Blue
11249 PROTEST THE HERO Bird Dive Navy Blue
15405 MEMPHIS MAY FIRE Light House Navy T-Shirt
15471 CROWN THE EMPIRE Axe Navy
18983 WE CAME AS ROMANS Wont Fade Away Navy
19822 MAYDAY PARADE Mistakes Navy
4596 BLINK182 BOXES T-Shirt
11261 CHUNK!NO,CAPTAIN CHUNK! Bats Navy
21123 ATTILA Rage Tomahawk Royal Blue
24762 NORTHLANE Glitch Navy - T-Shirt
25243 CHUNK!NO,CAPTAIN CHUNK! Shut Up Navy - T-Shirt
26271 DESCENDENTS Van
26280 DROPKICK MURPHYS Basebrawl
26321 STRUNG OUT OG Logo Navy
37124 KEYTALK カレッジTシャツ ネイビー