SELECT SQL_CALC_FOUND_ROWS 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 >= '2021-01-18 09:09:20')
AND pc.price02 > 4545
AND price02 <= 9090
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57313 ZERO EVOKE Three Needles Sweat 【BLACK】
57314 ZERO EVOKE Three Needles Sweat 【WHITE】
57315 ZERO EVOKE ZE Logo Second Pullover Parka 【BLACK×BLACK】
57316 ZERO EVOKE ZE Logo Second Pullover Parka 【WHITE×WHITE】
57311 【予約商品】ゲキクロ限定 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt Black
57312 【予約商品】ゲキクロ限定 HEDWiNG Creepy-ART Big shilhouette L/S T-shirt White
57299 【予約商品】HEDWiNG Drop Shoulder Light Hoodie Black
57300 【予約商品】HEDWiNG Drop Shoulder Light Hoodie Beige
57301 【予約商品】HEDWiNG “W”ave Longsleeve T-shit Black
57302 【予約商品】HEDWiNG “W”ave Longsleeve T-shit White
57303 【予約商品】HEDWiNG Creepy-ART Big shilhouette T-shirt Black
57304 【予約商品】HEDWiNG Creepy-ART Big shilhouette T-shirt White
57305 【予約商品】HEDWiNG Pocket “MOJYAPON” T-shirt Navy
57306 【予約商品】HEDWiNG Pocket “MOJYAPON” T-shirt White
57309 【予約商品】HEDWiNG Flamingo Skater Cap Black
57310 【予約商品】HEDWiNG Flamingo Skater Cap Off pink
57294 BRING ME THE HORIZON UNISEX TEE: PARASITE (BACK PRINT)
57296 SLIPKNOT UNISEX PULLOVER HOODIE: GOAT-S (BACK PRINT)
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
55894 SALUTE WASHED FLOWER VINTAGE TEE PURPLE
55893 SALUTE FLOWER ANARCHY BRACELET
43265 SILLENT FROM ME STIGMA -Pullover- WHITE
50394 SILLENT FROM ME SMILE -Ziphood- WHITE
39981 SILLENT FROM ME MESS -Pullover- Black
39846 SILLENT FROM ME ALEXIA -Crew Sweat- Black
57283 MISHKA GALACTIC GHOULS LS TEE WHITE
57284 MISHKA FLAMING KEEP WATCH LS TEE
57285 MISHKA 2 CHILL 4 DEATH LS TEE BLACK
57286 MISHKA 2 CHILL 4 DEATH LS TEE LIME
57287 MISHKA STACKED LS TEE BLACK
57288 MISHKA STACKED LS TEE LIME
35558 BRING ME THE HORIZON BANNER HOODIE
57269 BRING ME THE HORIZON UNISEX LONG SLEEVED TEE: PARANOID (BACK PRINT)
57270 BRING ME THE HORIZON UNISEX TEE: FLOWERS (BACK PRINT)
57236 BRING ME THE HORIZON UNISEX TEE: HEX PHSH COVER (BACK PRINT)
57237 BRING ME THE HORIZON UNISEX TEE: LOVE (BACK PRINT)
57239 BRING ME THE HORIZON UNISEX TEE: WIPE THE SYSTEM (BACK PRINT)
57238 BRING ME THE HORIZON UNISEX TEE: THE END (BACK PRINT)
36789 SLIPKNOT Gray Chapter Skeleton Hooded Sweatshirt
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
53185 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: CROWN OF ROSES
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
55669 DI:VISION SPLIT-LINE TRACK PANTS
56492 DI:VISION MESSAGE HOODIE BLACK
56497 DI:VISION SALVAGE LS TEE WHITE
56506 DI:VISION VOID LAYERED BOADER CUT-SEW WHITE
56401 Subciety SNAP BACK CAP-SERVER- BLACK/WHITE
56385 Subciety BEANIE-SERVER - BLACK
56586 GALFY 犬っていいかもTee 漆黒
56587 GALFY 犬っていいかもTee 美白
57254 ガリュウホンポ 猫ロングTシャツ
57255 ガリュウホンポ 子猫ロングTシャツ
57256 ガリュウホンポ 金魚ラグラン
57257 ガリュウホンポ マスクロングTシャツ
57258 ガリュウホンポ スーサイドロングTシャツ
56763 田中聖×GoneR×GEKIROCK CLOTIHNG Collaboration Parka Black
56764 田中聖×GoneR×GEKIROCK CLOTIHNG Collaboration Parka White
56831 Subcietyx攻殻機動隊 Cyberbrain L/S BLACK
56832 Subcietyx攻殻機動隊 TACHIKOMA L/S WHITE
56835 Subcietyx攻殻機動隊 TACHIKOMA L/S BLUE
56838 Subcietyx攻殻機動隊 TACHIKOMA L/S BLACK
56839 Subcietyx攻殻機動隊 Cyberbrain L/S PURPLE
56841 Subcietyx攻殻機動隊 Cyberbrain L/S WHITE
57226 Artemis Classic トレサリー天然ラピス数珠ブレス
57227 Artemis Classic ラピスワックスコードシングルブレス
57228 Artemis Classic オニキスワックスコードWブレス
57231 Artemis Classic フローラルカラビナキーホルダーパイソン
57221 TOY MACHINE CLAIRVOYANT BB CAP - BLACK
57222 TOY MACHINE CLAIRVOYANT BB CAP - WHITE
56339 NineMicrophones SNAP BACK CAP-NM/CS- BLACK/RED
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57207 NieR WIND BREAKER【闇】
57213 NieR ふわもこBLACK PARKA
57211 NieR 防寒裏起毛BLACK PARKA
57212 NieR UNISEX LONG ワンピース【耳付き】
56649 PUNK DRUNKERS 反区怒飯店ロンTEE - WHITE
57183 acOlaSia STAFF L/S WHITE
57185 acOlaSia 煙仄 L/S BLACK
57186 acOlaSia 煙仄 L/S WHITE
57197 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE RED
57198 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE BLUE
57199 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” LONG TEE PURPLE
56493 DI:VISION MESSAGE HOODIE GRAY
56883 MISHKA(ミシカ) MAW203117 WHITE
30782 Zephyren(ゼファレン) PAISLEY G.I BELT BLACK
30783 Zephyren(ゼファレン) PAISLEY G.I BELT WHITE
57108 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE WHITE
57109 TOY MACHINE FLAME FIST EMBROIDERY LONG TEE BLACK
57110 TOY MACHINE SECT STAFF GRADATION LONG TEE WHITE
57111 TOY MACHINE SECT STAFF GRADATION LONG TEE BLACK
57112 TOY MACHINE CLAIRVOYANT LONG TEE WHITE
57113 TOY MACHINE CLAIRVOYANT LONG TEE NEON YELLOW
57114 TOY MACHINE CLAIRVOYANT LONG TEE BLACK
57115 TOY MACHINE WELCOME TO HELL LONG TEE BLACK
56322 NineMicrophones Lipsand Microphone S/S WHITE
56323 NineMicrophones Lipsand Microphone S/S GRAY
56325 NineMicrophones NM/CS S/S BLACK
56326 NineMicrophones NM/CS S/S BURGUNDY
57099 Survive Said The Prophet MONO TONE HOODIE
57100 Survive Said The Prophet SIDE ZIP HOODIE
57101 Survive Said The Prophet WATER PROOF COACH JKT (BLACK)
27888 DISTURBIA CLOTHING (ディスタービア・クロージング) Riot Grrrl Necklace
27889 DISTURBIA CLOTHING (ディスタービア・クロージング) Slay Necklace
27884 DISTURBIA CLOTHING (ディスタービア・クロージング) Nobody Necklace
27885 DISTURBIA CLOTHING (ディスタービア・クロージング) Weirdo Necklace
27886 DISTURBIA CLOTHING (ディスタービア・クロージング) Alien Necklace
57089 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T BLACK
57090 RUDIE'S RUDIE'S x BYRD / LOOK SLICK-T WHITE
57091 RUDIE'S RUDIE'S x BYRD / LOOK SLICK LS-T BLACK
57092 RUDIE'S RUDIE'S x BYRD / LOOK SLICK LS-T WHITE
57075 NieR WIDE NECK CUTSEW【Emerald】
57080 NieR 総柄LONG CUTSEW
57063 ANIMALIA AN20A-CP03 “R.I.B.” BOMBER CAP BLACK
57064 ANIMALIA AN20A-CP03 “R.I.B.” BOMBER CAP OLIVE
57059 CIVARIZE【シヴァーライズ】 多重クロスオリジナルチェーンブレスレット Black
57060 CIVARIZE【シヴァーライズ】 多重クロスオリジナルチェーンブレスレット Silver
57062 CIVARIZE【シヴァーライズ】 多重クロスオリジナルチェーンネックレス Silver
56250 KAVANE Clothing "DAZE"Long Sleeve
56957 MAGICAL MOSH MISFITS x SONIC THE HEDGEHOG“MAGICAL SONIC MISFITS” LONG TEE RED
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[/] =>
[price] => 3
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/?work=new_arrival&price=3
--------
mb_parse_str
Array
(
[work] => new_arrival
[/] =>
[price] => 3
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&/