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 (
SELECT product_id, category_id
FROM dtb_product_categories
WHERE category_id =588
)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 >= '2021-03-02 04:56:05')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
58068 【予約商品】RUDIE'S x CRAYON SHINCHAN PEACE HOOD SWEAT BLACK
58069 【予約商品】RUDIE'S x CRAYON SHINCHAN PEACE HOOD SWEAT NATURAL
35558 BRING ME THE HORIZON BANNER HOODIE
51194 SLIPKNOT UNISEX PULLOVER HOODIE: GRAPHIC GOAT (BACK PRINT)
51195 SLIPKNOT UNISEX PULLOVER HOODIE: SPLATTER (BACK PRINT)
57234 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: HEX PHSH COVER
57297 SLIPKNOT UNISEX PULLOVER HOODIE: CHOIR (BACK PRINT)
58067 FOO FIGHTERS UNISEX PULLOVER HOODIE: MEDICINE AT MIDNIGHT TAPED
58056 NOT COMMON SENSE NCS SNAKE HOODIE WHITE
58057 NOT COMMON SENSE NCS FLAME HOODIE WHITE
58058 NOT COMMON SENSE NCS FLAME HOODIE BLACK
58048 【予約商品】XrossOver BigParka
58029 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - L. PINK
58030 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - BLACK
58031 TOY MACHINE OG MONSTER EMBROIDERY SWEAT PARKA - TAN
58015 ROLLING CRADLE FIRE HOODIE / PURPLE
57976 TRAVAS TOKYO【トラバストーキョー】エンジェルハートプルオーバーパーカー BLACK
57977 TRAVAS TOKYO【トラバストーキョー】エンジェルハートプルオーバーパーカー WHITE
57978 TRAVAS TOKYO【トラバストーキョー】ファンシークラゲプリントモアビッグパーカー Black×Red
58001 RUDIE'S GOOD VIBRATION HOOD SWEAT BLACK
58002 RUDIE'S GOOD VIBRATION HOOD SWEAT BLUE
58003 RUDIE'S GOOD VIBRATION HOOD SWEAT PINK
57834 【予約商品】DI:VISION UNRAVEL HOODIE BLACK
57835 【予約商品】DI:VISION MYOB HOODIE BLACK
57836 【予約商品】DI:VISION UNRAVEL HOODIE WHITE
57837 【予約商品】DI:VISION MYOB HOODIE WHITE
57825 SILLENT FROM ME EYE -Pullover- WHITE
57826 SILLENT FROM ME EYE -Pullover- BLACK
57202 神使轟く、激情の如く。× GEKIROCK CLOTHING 限定コラボ・パーカー
57277 Subciety PARKA-PROVIDENCE- BLACK
57278 Subciety PARKA-PROVIDENCE- GRAY
57279 Subciety PARKA-PROVIDENCE- NAVY
57803 ROLLING CRADLE LMS HOODIE / BLACK
57223 ゲキクロ限定カラーKAVANE Clothing×アルルカン 暁 "MOONRAKERS"OVERSIZE HOODIE(RED)
57224 ゲキクロ限定カラーKAVANE Clothing×アルルカン 暁 "MOONRAKERS"OVERSIZE HOODIE(BLK)
57225 ゲキクロ限定カラーKAVANE Clothing×アルルカン 暁 "MOONRAKERS"OVERSIZE HOODIE(PUR)
57800 CRADLE OF FILTH The Principle Of Evil Made Flesh Hoodie
56459 Subciety SOUVENIR PARKA- PINK
56458 Subciety SOUVENIR PARKA- KHAKI
56457 Subciety SOUVENIR PARKA- BLACK
57408 THRASHER TH8501PL MAG LOGO HOODIE BLK/WHT
57409 THRASHER TH8501PL MAG LOGO HOODIE GRAY
57410 THRASHER TH8501PL MAG LOGO HOODIE RED
57411 THRASHER TH8501PL MAG LOGO HOODIE GREEN
57412 THRASHER TH8501PL MAG LOGO HOODIE NAVY
57413 THRASHER TH8528PLGONZ HOODIE BLACK
57414 THRASHER TH8528PLGONZ HOODIE WHITE
57415 THRASHER TH8528PLGONZ HOODIE GRAY
57407 FOG ESSENTIALS Riflector Logo Hoodie PINK
57396 FILA FS3025 HOODIE WHITE
57397 FILA FS3025 HOODIE NAVY
57376 RUDIE'S PHAT HOOD SWEAT GRAY
57377 RUDIE'S PHAT HOOD SWEAT PURPLE
57378 RUDIE'S PHAT HOOD SWEAT BLACK
56907 Unlucky Morpheus×GEKIROCK CLOTHING 限定コラボ・パーカー
57351 SUPPLIER LOGO HOODIE RED
57316 ZERO EVOKE ZE Logo Second Pullover Parka 【WHITE×WHITE】
56633 PUNK DRUNKERS 骨ジャンケンパーカ - BLACK
56634 PUNK DRUNKERS 骨ジャンケンパーカ - PURPLE
57339 MISHKA M21000403 HOODIE BLACK
57340 MISHKA M21000403 HOODIE ORANGE
56449 Subciety VANDALIZE PARKA- BLACK
56451 Subciety VANDALIZE PARKA- KHAKI
56307 NineMicrophones PARKA-Pain of My life BLACK
56308 NineMicrophones PARKA-Pain of My life GRAY
56314 NineMicrophones PARKA-Sunforever2021- GRAY
56934 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・パーカー BLACK
56935 TEARS OF TRAGEDY×GEKIROCK CLOTHING 限定コラボ・パーカー WHITE
56919 Half time Old×GEKIROCK CLOTHING 限定コラボ・パーカー
57315 ZERO EVOKE ZE Logo Second Pullover Parka 【BLACK×BLACK】
57235 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: THE END (ARM PRINTS)
57295 IRON MAIDEN UNISEX PULLOVER HOODIE: LOTB LIVE ALBUM (ARM & BACK PRINT)
57296 SLIPKNOT UNISEX PULLOVER HOODIE: GOAT-S (BACK PRINT)
56485 SALUTE Flower Anarchy Hoodie BLACK
56484 SALUTE Flower Anarchy Hoodie BLUE
57280 MISHKA FLAMING KEEP WATCH HOODIE
57281 MISHKA STACKED HOODIE
57282 MISHKA GALACTIC GHOULS HOODIE
57233 BRING ME THE HORIZON UNISEX PULLOVER HOODIE: LOVE (BACK PRINT)
53185 BULLET FOR MY VALENTINE UNISEX PULLOVER HOODIE: CROWN OF ROSES
56762 RAMONES UNISEX PULLOVER HOODIE: PRESIDENTIAL SEAL
56492 DI:VISION MESSAGE HOODIE BLACK
56454 Subciety BREAK PARKA- BLACK
56455 Subciety BREAK PARKA- YELLOW
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
57250 ガリュウホンポ 子猫プルオーバーパーカー
56763 田中聖×GoneR×GEKIROCK CLOTIHNG Collaboration Parka Black
56764 田中聖×GoneR×GEKIROCK CLOTIHNG Collaboration Parka White
56829 Subcietyx攻殻機動隊 CONNECT PARKA BLACK
56830 Subcietyx攻殻機動隊 SECTION9 PARKA BLACK
56833 Subcietyx攻殻機動隊 SECTION9 PARKA GRAY
56834 Subcietyx攻殻機動隊 CONNECT PARKA GRAY
56836 Subcietyx攻殻機動隊 SECTION9 PARKA KHAKI
56837 Subcietyx攻殻機動隊 CONNECT PARKA KHAKI
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
57213 NieR ふわもこBLACK PARKA
57211 NieR 防寒裏起毛BLACK PARKA
56637 PUNK DRUNKERS スピーカーパーカ - BLACK
56638 PUNK DRUNKERS スピーカーパーカ - M.GRAY
57181 acOlaSia poison hoodie WHITE
57182 acOlaSia poison hoodie BLACK
56493 DI:VISION MESSAGE HOODIE GRAY
55040 Zephyren(ゼファレン)FUR PARKA BLACK
55021 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - MUSTARD
55020 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - GREEN
55019 Zephyren(ゼファレン)DOLMAN BIG PARKA - Kaleidoscope - BLACK
57099 Survive Said The Prophet MONO TONE HOODIE
57100 Survive Said The Prophet SIDE ZIP HOODIE
56041 CIVARIZE×DIAURAコラボDICTATORオーバーサイズパーカー
57093 RUDIE'S RUDIE'S x BYRD / LOOK SLICK HOOD SWEAT BLACK
57094 RUDIE'S RUDIE'S x BYRD / LOOK SLICK HOOD SWEAT GRAY
56895 SALUTE CACTUS PRINTER HOODIE
57071 SALUTE WASHED TARGET HOODIES
56970 NOT COMMON SENSE LIGHTNING HOODED SWEATSHIRT
56953 MAGICAL MOSH MISFITS ぷよぷよ x まじかる “ぷよぷよもっしゅみすふぃっつ” ぱーか くろ
56480 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・パーカー WHITE
56481 Leetspeak monsters×GEKIROCK CLOTHINGコラボ・パーカー ORANGE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 588
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=588
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 588
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=588