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 =211
)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-04-23 02:05:20')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
51677 MUSIC SAVED MY LIFE M201-02L1-CS03 LONG TANK TOP WHITE
58189 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]マッスルタンク - WHITE
58190 【予約商品】PUNK DRUNKERS [PDSxなかやまきんに君]マッスルタンク - BLACK
58350 CIVARIZE【シヴァーライズ】バイカラー切り替えロンT&タンクトップセット
15637 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- WHT
15638 ZEPHYREN (ゼファレン) TANK TOP -BEYOND- BLK
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56290 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (BLACK)
56291 CIVARIZE【シヴァーライズ】ROSE BIG L/S TEE+TANK TOP (WHITE)
56214 Anti Social Social Club Goodbye Summer Black Tank
56121 SILLENT FROM ME DOUGLAS Fuzzy Tank Top
55808 SUBLIME×SULLEN HEAD HIGH STANDARD TANKTOP
55683 RIP DESIGN WORXX スラッシュロゴメッシュタンクトップ BLACK
55684 RIP DESIGN WORXX スラッシュロゴメッシュタンクトップ WHITE
54163 GoneR Rose Logo Tank-Top White
54166 GoneR Day of the Dead Tank-Top White
53277 Zephyren(ゼファレン)BIG TANKTOP WHITE / pagan
53278 Zephyren(ゼファレン)BIG TANKTOP BLACK / pagan
13159 Subciety TANK TOP -TRUST-BLACK/WHITE
17675 Subciety TIE DYE TANK TOP-GLORIOUS- BURGUNDY
17676 Subciety TIE DYE TANK TOP-GLORIOUS- BLK
17695 Subciety TIE DYE TANK TOP-GLORIOUS- NAVY
48361 Subciety (サブサエティ) TANKTOP-TAG- WHITE
24869 GoneR Photo Logo Tank-Top White
24870 GoneR Photo Logo Tank-Top Black
24871 GoneR GoneR Dot Tank-Top White
6317 MISHKA (ミシカ) CYRILLIC GORE DRIP TANK BLACK
9314 MEMPHIS MAY FIRE Challenger Black Tank Top
9415 WE CAME AS ROMANS Sideways Black Tank Top
10822 MISHKA (ミシカ) CYCO PUSHER TANK TOP TIE-DYE
10832 MISHKA (ミシカ) KEEP WATCH TANK RED
11064 VANS APPAREL BURKE TANK TOP GREY
11091 MISHKA (ミシカ) THE WORLD WIDE WEIRDOS TANK GREEN TIE DYE
11436 ATTILA Reaper Navy/Heather Tank Top
11652 FAMOUS STARS AND STRAPS TIGER TEXT Tank
11657 FAMOUS STARS AND STRAPS FAM RESPECT Tank WHT
12194 MISHKA (ミシカ) BEAST OF THE EAST TANK TOP ARMY
12206 MISHKA (ミシカ) KEEP WATCH DYNASTY TANK TOP GOLD
12210 MISHKA (ミシカ) CRYPT KEEPER TANK TOP WHITE
12420 SRH Sniper Camo TankTop
12641 ROLLING CRADLE RC-BA TANK Lightblue×Red
12642 ROLLING CRADLE RC-BA TANK Red×Blue
13188 VANS APPAREL WAVE STRIPE TANK TOP WHITE/RED
14194 DISTURBIA CLOTHING REMEMBER THE FUTURE VEST
15016 HER NAME IN BLOOD RETURN OF THE BEAST TOUR TANK WH
15346 WHITECHAPEL Spark Black Tank Top
15383 WITHIN THE RUINS Red Crest Black Tank Top
15402 MEMPHIS MAY FIRE Ordinary Love Red Tank Top
15425 ISSUES Logo White Tank Top
15431 THE WORD ALIVE Press Photo White Girl's Tank Top
15515 WE CAME AS ROMANS Ancestor Heather Grey Tank Top
15579 SECRETS Heart Black Tank Top
16776 FAMOUS STARS AND STRAPS GOTHIC ROSBUD JRS FLOWY
16788 FAMOUS STARS AND STRAPS OG BOH MENS TANK DENIM
16789 FAMOUS STARS AND STRAPS OG BOH MENS TANK YEL
16983 ZEPHYREN (ゼファレン) TANK TOP -BONEYARD- - BLACK
19836 MAYDAY PARADE Upstage White Tank Top
19868 SQUARE FLOWER TANKTOP RED
19869 SQUARE FLOWER TANKTOP BLUE
19889 KILL STAR CLOTHING SPIRITUS VEST [B]
19934 SQUARE EYE TANKTOP
20123 KILL STAR CLOTHING CATS MUSCLE TANK [B]
20339 AGAPE ATTIRE CLASSIC SCRIPT TANK
20593 FAMOUS STARS AND STRAPS LOCKED IN JERSEY TANK
21107 Stay Sick Clothing Carl All-Over
21199 Stay Sick Clothing Finger All-Over - TankTop
21204 Stay Sick Clothing I'm Not Deaf Black - Tank Top
21218 Stay Sick Clothing Pear White - TankTop
21369 FAMOUS STARS AND STRAPS Turnt Wreath Muscle Tank B
22790 DIAWOLF DW ONE-PIECE TANK
22939 REBEL8 STANDARD ISSUE BLACK TANK
22940 REBEL8 STANDARD ISSUE WHITE TANK
23684 SPITFIRE Bighead Grey Spiral Black Rib
24425 Hypocrite(ヒポクリット) The Psyboxlogo Tank WB
24426 Hypocrite(ヒポクリット) The Psyboxlogo Tank BW
24668 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) Wild Patriot Tank Top RED
24700 MEMPHIS MAY FIRE Logo Two Tone - TankTop
25234 CHUNK!NO,CAPTAIN CHUNK! City Night White - TankTop
25313 EMAROSA Side Fox Tr-Blend Heather Grey - TankTop
25486 PIERCE THE VEIL Album Black - T-ShirtStitches Heather Blue - Tank Top
26469 DEADHEARTZ "Blood" MESH TANKTOP / CAMO
26536 RideMe R Logo Tanktop WHITE
26566 MISHKA (ミシカ) DAMAGED KEEP WATCH TANK
27365 SQUARE FAMOUS ICONS TANK TOP BLACK
27861 DISTURBIA CLOTHING REVENGE HALTER TOP
27863 DISTURBIA CLOTHING ESOTERIC 3/4 CROP TOP
27895 DISTURBIA CLOTHING (ディスタービア・クロージング) SHIBORI TOP
28115 Xmas Eileen 『WORLD COUNTDOWN』タンクトップ WHT
28116 Xmas Eileen 『WORLD COUNTDOWN』タンクトップ BLK
28143 KILL STAR CLOTHING (キルスター・クロージング) People Tank [B]
28249 STAY SICK CLOTHING Forest Anchor White
28310 FRONZILLA Party People's Anthem Black TankTop
29110 KILL STAR CLOTHING (キルスター・クロージング) Dark Side Tank [B]
32573 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) BONE F TEE BLK
32576 FAMOUS STARS AND STRAPS (フェイマス・スターズ・アンド・ストラップス) DEAD ROSE Tank Top
33842 ANIMALIA AN17U-TE08 FIGHT IT OUT WHITE
34318 SQUARE JUNK PATTERN MESH TANKTOP White
35077 REBEL8 Dalmae Slouchy Tank
35078 REBEL8 Down The Hatch Racerback Tank
35084 REBEL8 Lakeview Embroidered Tank
35168 REBEL8 Logo Chest Tank White
35169 REBEL8 Logo Chest Tank Black
37838 Xmas Eileen DIS IS LOVEタンクトップ(黒)
37839 Xmas Eileen DIS IS LOVEタンクトップ(白)
38668 VIRGO VG-JKT-178 UMA stretch boa vest black
44008 SLIGHTLY NUMB LIBERATION SLEEVELESS TEE
45502 TOY MACHINE TMS19ST30 TOYMACHINE LOGO EMBROIDERY TANK TOP WHITE
45503 TOY MACHINE TMS19ST30 TOYMACHINE LOGO EMBROIDERY TANK TOP BLACK
45504 TOY MACHINE TMS19ST31 BRAINWASH GRADATION PRINT TANK TOP WHITE
46317 SANTA CRUZ CLASSIC DOT TANK WHITE
46318 SANTA CRUZ CLASSIC DOT TANK BLACK
47305 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) BLACK
47306 MUSIC SAVED MY LIFE (MSML) M1K1K-CS03 LAYERED TANK TOP (スカルプリント) WHITE
47585 MUSIC SAVED MY LIFE (MSML) M1K1K-CS04 LAYERED TANK TOP (パンサープリント) WHITE
48113 KILL STAR CLOTHING Cat Lady Lace-Up Tunic
48251 NOT COMMON SENSE WWF×NCS MM TANK WHITE
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 211
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=211&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 211
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=211