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 13:56:24')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND FIND_IN_SET(1, p.color)
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]
65536 NieR (ニーア) NieRちゃん×CROSS×LOGO総柄CUTSEW
69071 NieR (ニーア) 超BIG SILHOUETTE CUTSEW【WHITE CRASH】
14707 RUDIE'S SPARK SNAPBACK CAP BLACK/WHT
67643 PUNK DRUNKERS(パンクドランカーズ)コミカルブラザーズBIG.TEE - BLACK
63328 Meltyglow (メルティグロウ) 総柄半袖PARKA【Fall melty】
65539 NieR (ニーア) 超OVERSIZE SILHOUETTE CUTSEW【FIRE×HEART】
69095 NieR (ニーア) 軽量サルエルパンツ【和柄九尾(赤)】
70760 NieR (ニーア) 8.4oz LONG LENGTH LOGO PARKA【BLACK】
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
27638 ANIMALIA AN16A-TE02 AA FLAG BLACK
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
58063 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT
58065 FOO FIGHTERS UNISEX TEE: MEDICINE AT MIDNIGHT TAPED
64915 ANIMALIA (アニマリア) SCRIPT BLACK
64917 ANIMALIA (アニマリア) TITLE BLACK
64919 ANIMALIA (アニマリア) EASY NYLON SHORTS BLACK
65518 NieR (ニーア) FRILLED SLEEVES TEE
65912 SABBAT13(サバトサーティーン) SPOOK BOA NECK WARMER (BK)
68239 TOY MACHINE (トイマシーン) SLING SHOT SS TEE BLACK
68241 TOY MACHINE (トイマシーン) DOESN'T LOVE YOU SS TEE BLACK
68474 HEDWiNG (ヘドウィグ) Two Tone Ball Cap BLACKxBURGUNDY
68739 ANIMALIA (アニマリア) NYLON BUCKET HAT-LOGO BLACK
68936 gibous(ギボス) 9photo tshirt black
69138 gibous(ギボス) side girl print t shirt BLACK
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
71413 GoneR (ゴナー) Graffiti Logo T-Shirts Black
71433 TOY MACHINE (トイマシーン) THREE COLOR FIST SS TEE BLACK
64319 NieR (ニーア) OFF-SHOULDER PULLOVER【MADNESS GIRL】
28486 THRASHER (スラッシャー) TH8301 MAG LOGO LONG TEE BLK/WHT
40871 HOLDTUBE HT-0427 TOUCH FUSION PEACE BLOSSOM
49071 HOLDTUBE HT-0435 TOUCH FUSION DEEP WARP2
58036 TOY MACHINE SECT MARK PRINT SS TEE - BLACK
63006 TOY MACHINE (トイマシーン) SECT WAX EMBROIDEY SS TEE - BLACK
63230 TOY MACHINE (トイマシーン) LOYAL PAWN EMBROIDERY SS TEE - BLACK
69550 GALFY (ガルフィー) 犬耳ニット帽 RED/BLACK
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】
8107 RUDIE'S (ルーディーズ) SPARK 3/4 RAGLAN WHITE/BLACK
8108 RUDIE'S (ルーディーズ) SPARK 3/4 RAGLAN BLACK/BLACK
11285 Nine Microphones BE ON STAGE S/S BLACK
18447 Subciety GLORIOUS S/S - BLACK/WHITE
19010 WHITECHAPEL Thirst Black
20303 REBEL8 GR8FUL TEE
20483 FAR★STAR 百目♀鼠 T&ショートT
22188 KILL STAR CLOTHING(キルスター・クロージング) Azrael T-Shirt
24859 RUDIE'S PHAT SNAPBACKCAP BLACK
25188 IWRESTLEDABEARONCE W Paw Black - Long Sleeve Shirt
25228 LIKE MOTHS TO FLAMES TDTWLF Torch Black - Long Sleeve
25449 MAYDAY PARADE Pom Beanie
28821 RIP DESIGN WORXX RIPDW LOGO LONG T-SHIRT(ブラック)
29109 KILL STAR CLOTHING (キルスター・クロージング) Cozmic Death Crop Top [B]
36703 RUDIE'S (ルーディーズ) KHAOS Mobile Battery
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
50186 SAMURAI CORE SR-TE-07-B SAMURAI CORE tee BLACK
51362 KILL STAR CLOTHING Diablerie T-Shirt
51376 極東ロマンス×acOlaSia ゲキクロ限定コラボ L/S T-Shirt
55886 GoneR -La Neta- GRL02CP002 Agave Boa Jockey Cap Black
56385 Subciety (サブサエティ) BEANIE-SERVER - BLACK
57798 CRADLE OF FILTH Krampus T-shirt + ornament
60204 Anti Social Social Club No Drama Black Socks
60524 うみくん×GEKIROCK CLOTHING×KAVANE Clothingコラボ・ロンT
61420 VIRGO (ヴァルゴ) GLOWING EYES BLACK
62313 Zephyren(ゼファレン) TANKTOP - BEYOND - BLACK
62821 RUDIE'S (ルーディーズ) x CRAYON SHINCHAN MOSH METROHAT BLACK
63259 沢城千春×SABBAT13×GEKIROCK CLOTHING Lying T-Shirt BLACK
63302 Anti Social Social Club Collapse White Socks
63313 GoneR (ゴナー) GR33CT004 Mexican Pattern T-Sirts Black
64197 Subciety (サブサエティ) GLORIOUS S/S BLACK
65219 LONELY論理 LONELY論理×SANRIO KUROMI TAGGING CANVAS TOTE-BLACK
65302 松山 ダリア×GoneR コラボ 限定 キャップ
65629 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) モコモコボアのバケットハット-BLACK
65634 MAGICAL MOSH MISFITS (マジカルモッシュミスフィッツ) ぬくぬくCAP (フリース)-BLACK
66771 NieR (ニーア) SLEEVE LOGO PULLOVEVR PARKA
67528 Broken By The Scream×HYPER CORE×GEKIROCK CLOTHING コラボ・バッグ
67970 SLIPKNOT UNISEX LONG SLEEVE T-SHIRT: SPIT IT OUT
67973 YUNGBLUD UNISEX LONG SLEEVE T-SHIRT: SCRATCH LOGO (WASH COLLECTION)
68027 GoneR(ゴナー) GR36CT002 Cheart T-Shirts Black
68031 GoneR(ゴナー) GR36LS001 Fire Rose L/S T-Shirts Black
68033 GoneR(ゴナー) GR36LS002 Cross Mexican Skull L/S T-Shirts Black
68035 GoneR(ゴナー) GR36LS003 Rose “GR” L/S T-Shirts Black
68058 MISHKA (ミシカ) CREAMY TEE (BLACK/MIJT-01BLK)
68230 TheBackOfBoys(ザバックオブボーイズ) CITY GRAFFITI TEE HEATHER BLACK
68234 TheBackOfBoys(ザバックオブボーイズ) CUTE GIRL TYPE2 TEE BLACK
68247 BAD BOY (バッドボーイ) PARODY LOGO WAPPEN TEE BLACK
68250 BAD BOY (バッドボーイ) RAKUGAKI LOGO WAPPEN TEE BLACK
68253 BAD BOY (バッドボーイ) BADBOY SPACE LOGO WAPPEN TEE BLACK
68292 RUDIE'S (ルーディーズ) BLOCK COLLEGE METROHAT BLACK
68294 RUDIE'S (ルーディーズ) EXTRA DRAWING-T BLACK
68334 倉知玲鳳×NOT COMMON SENSE×GEKIROCK CLOTHINGスペシャル・コラボ・トートバッグ
68341 CMP LABEL (シーエムピーレーベル) CHAOTIC oversized T-shirt
68342 CMP LABEL (シーエムピーレーベル) Antinomie oversized T-shirt
68384 SABBAT13(サバトサーティーン) PLAY SONG T (BLACK)
68387 SABBAT13(サバトサーティーン) FATE T (SMOKE BLACK)
68440 SABBAT13(サバトサーティーン) SCAPEGOAT T (BLACK)
68458 RUDIE'S (ルーディーズ) KILLER TUNE PLAYER-T BLACK
68486 over print (オーバープリント) Half Top BLACK
68488 over print (オーバープリント) Biker Pants BLACK
68789 曙 涼×NOT COMMON SENSEコラボ限定サコッシュ
68905 TheBackOfBoys(ザバックオブボーイズ) SORE LOSER TEE BLACK
68909 TheBackOfBoys(ザバックオブボーイズ) PREMONITION OF SUMMER TEE BLACK
68912 TheBackOfBoys(ザバックオブボーイズ) CHEESE&MOUSE TEE NAVY
68969 PSYCHOLOGICAL METAMORPHOSIS PM BB CAP BLACK
68983 HEDWiNG (ヘドウィグ) Space Logo Bucket hat BLACK
69027 Gurin. ×PSYCHOLOGICAL METAMORPHOSIS EYES TEE BLACK
69211 GoneR(ゴナー) GR37CT002 Rose Ribbon T-Shirt Black/Red