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-04-28 12:44:46')
AND pc.price02 > 4545
AND price02 <= 9090
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 MAX(price02)
LIMIT 0, 120
18105 KILL STAR CLOTHING SPACE GRASS T-SHIRT [B]
60463 NieR (ニーア) BACK RABBIT CHECKERED CUTSEW 【RED PINK】
61057 NieR (ニーア) ミケLONGSLEEVE CUTSEW
61059 NieR (ニーア) logo LONGSLEEVE CUTSEW
65536 NieR (ニーア) NieRちゃん×CROSS×LOGO総柄CUTSEW
69071 NieR (ニーア) 超BIG SILHOUETTE CUTSEW【WHITE CRASH】
69096 NieR (ニーア) 迷彩ミケ 超BIG SILHOUETTE CUTSEW
69097 NieR (ニーア) 超BIG SILHOUETTE RED CUTSEW 【WHITE×RED】
14707 RUDIE'S SPARK SNAPBACK CAP BLACK/WHT
67643 PUNK DRUNKERS(パンクドランカーズ)コミカルブラザーズBIG.TEE - BLACK
69888 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - D.BLUE
69889 PUNK DRUNKERS(パンクドランカーズ) 毒キノコTEE - S.PINK
70992 【予約商品】PUNK DRUNKERS NONフィクションBIG.TEE - WHITE
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
65539 NieR (ニーア) 超OVERSIZE SILHOUETTE CUTSEW【FIRE×HEART】
68041 NieR (ニーア) フード付き半袖PARKA【ぐれまる】
68306 NieR (ニーア) SUPER OVER SIZE CUTSEW
68893 FACT101(ファクト・イチマルイチ) 「SMG」 Tシャツ_White
69095 NieR (ニーア) 軽量サルエルパンツ【和柄九尾(赤)】
70760 NieR (ニーア) 8.4oz LONG LENGTH LOGO PARKA【BLACK】
68359 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) HELLO KITTY x MxMxM “ともだち” TEE Mint
68360 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) HELLO KITTY x MxMxM “ともだち” TEE Black
69983 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) FIRE MOSH MISFITS CAP RED
69984 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) FIRE MOSH MISFITS CAP DOKU
70538 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM COLORS LOGO BB CAP BLACK
70539 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) MxMxM COLORS LOGO BB CAP PURPLE
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
27639 ANIMALIA AN16A-TE02 AA FLAG WHITE
36268 THRASHER THSR-SST01 BLK
41149 HOLDTUBEHT-2404 FLAP HOLDER PEACE BLOSSOM
41733 SQUARE CLEAR LENS SUNGLASS BLACK
50649 CHORD NUMBER EIGHT CHA1-01K5-AC09 CROSS NECKLACE
57991 GoneR GR28LS001 Rainbow Rose L/S T-Shirts Sand
58059 ANIMALIA AN21S-TE03 Tokyo Disregard WHITE×BLACK
63186 ANIMALIA (アニマリア) SLUB Tee S/S - logo WHITE
64914 ANIMALIA (アニマリア) SCRIPT WHITE
64915 ANIMALIA (アニマリア) SCRIPT BLACK
64916 ANIMALIA (アニマリア) TITLE WHITE
64917 ANIMALIA (アニマリア) TITLE BLACK
64918 ANIMALIA (アニマリア) EASY NYLON SHORTS LIME GREEN
64919 ANIMALIA (アニマリア) EASY NYLON SHORTS BLACK
65518 NieR (ニーア) FRILLED SLEEVES TEE
65655 SAMURAI CORE(サムライコア) 初期衝動宣言BELT WHITE
65912 SABBAT13(サバトサーティーン) SPOOK BOA NECK WARMER (BK)
66870 RIPNDIP (リップンディップ) Lord Nermal Beanie Black / Mint Tie Dye
68238 TOY MACHINE (トイマシーン) SLING SHOT SS TEE WHITE
68239 TOY MACHINE (トイマシーン) SLING SHOT SS TEE BLACK
68241 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE BLACK
68242 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE L. YELLOW
68243 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE WHITE
68473 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLUExKHAKI
68474 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLACKxBURGUNDY
68564 ANIMALIA (アニマリア) SIX PANELS MESH CAP-LOGO BLACK&RED
68565 ANIMALIA (アニマリア) SIX PANELS MESH CAP-LOGO GRAY
68739 ANIMALIA (アニマリア) NYLON BUCKET HAT-LOGO BLACK
68935 gibous(ギボス) 9photo t shirt white
68936 gibous(ギボス) 9photo tshirt black
69138 gibous(ギボス) side girl print t shirt BLACK
69139 gibous(ギボス) side girl print t shirt OFF WHITE
69216 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Grey
69217 GoneR(ゴナー) GR37CP001 Flat Visor Mesh Cap Black/Black
71411 GoneR (ゴナー) Graffiti Logo T-Shirts White
71412 GoneR (ゴナー) Graffiti Logo T-Shirts Charcoal
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
71432 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE WHITE
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
64319 NieR (ニーア) OFF-SHOULDER PULLOVER【MADNESS GIRL】
19063 HOLDTUBE HT-0403 TOUCH FUSION UNIVERSE
20366 THRASHER (スラッシャー) TH8301 MAG LOGO L/S T-SHIRT WHT
28486 THRASHER (スラッシャー) TH8301 MAG LOGO LONG TEE BLK/WHT
40870 HOLDTUBE HT-0424 TOUCH FUSION SHINY BANANA
40871 HOLDTUBE HT-0427 TOUCH FUSION PEACE BLOSSOM
49071 HOLDTUBE HT-0435 TOUCH FUSION DEEP WARP2
53161 TOY MACHINE TMS20ST2 LOGO GRADATION EMBRO SS TEE WHITE
57319 TOY MACHINE NEW BLOOD LOGO SIX PANEL CAP(SMOKE PINK)
57389 FILA FS3027 L/S T-Shirt NAVY
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
63005 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - YELLOW
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63229 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - WHITE
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
69550 GALFY (ガルフィー) 犬耳ニット帽 RED/BLACK
71401 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE PINK
71402 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE WHITE
71403 寝田ルネ×PSYCHO NATION(サイコネーション) 巫女TEE BLACK
70756 NieR (ニーア) SIDE TWO-TONE WING WIDE PANTS
70758 NieR (ニーア)2WAY SIDE ZIP WIDE PANTS【BRIGHT STAR】
70759 NieR (ニーア) 逆さONE君2WAY SIDE ZIP WIDE PANTS【骨ZIPPER】
68937 gibous(ギボス) snakescorpion t shirt baby blue
8107 RUDIE'S (ルーディーズ) SPARK 3/4 RAGLAN WHITE/BLACK
8108 RUDIE'S (ルーディーズ) SPARK 3/4 RAGLAN BLACK/BLACK
11229 Nine Microphones HEAVEN S/S Gray
11285 Nine Microphones BE ON STAGE S/S BLACK
11287 Nine Microphones BE ON STAGE S/S DENIM
18445 Subciety GLORIOUS S/S - WHITE/BLACK
18447 Subciety GLORIOUS S/S - BLACK/WHITE
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
23111 Subciety SALOON S/S NAVY/YELLOW
24859 RUDIE'S PHAT SNAPBACKCAP BLACK
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
28823 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(グレー)
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
36703 RUDIE'S (ルーディーズ) KHAOS Mobile Battery
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
42882 Subciety THE BASE S/S - ORANGE/WHITE
49739 NineMicrophones Pray with the microphone S/S WHITE
49740 NineMicrophones Pray with the microphone S/S BLACK
49764 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW ORANGE
49765 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW BLUE
49766 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW YELLOW
49767 【ゲキクロ限定】SILENT SIREN "NO GIRL NO CRY" S/S Tee Designed by RIPDW GREEN
50185 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee WHITE
50186 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee BLACK
51362 KILL STAR CLOTHING Diablerie T-Shirt
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
55652 THRASHER (スラッシャー) TH91214US FLAME OUTLINE S/S T-SHIRTS WHITE/YELLOW
55885 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Baige
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black