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 =395
)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 03:02:29')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
56567 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT PURPLE
57827 SILLENT FROM ME WORDS -Crew Sweat- WHITE
58298 KILL STAR CLOTHING Unholy Sabbath Sweatshirt
58288 ANIMALIA AN21S-SW04 DREAM CATCHER P/O SWEAT
58111 MISHKA M21000405 Crew
58113 MISHKA M21000414M WHITE
58112 MISHKA M21000414M BLACK
57341 MISHKA M21000402 SWEAT SHIRT BLACK
58032 TOY MACHINE DEAD MONSTER EMBROIDERY SWEAT CREW NECK - BLACK
57032 VIRGO Upright zip swt WHITE
57033 VIRGO Upright zip swt NAVY
57034 VIRGO Upright zip swt BLACK
57416 THRASHER TH8401PL MAG LOGO SWEAT BLK/WHT
57417 THRASHER TH8401PL MAG LOGO SWEAT WHITE
57418 THRASHER TH8401PL MAG LOGO SWEAT GRAY
57419 THRASHER TH8401PL MAG LOGO SWEAT RED
57420 THRASHER TH8401PL MAG LOGO SWEAT NAVY
57421 THRASHER TH8428PLGONZ SWEAT BLACK
57422 THRASHER TH8428PLGONZ SWEAT WHITE
57423 THRASHER TH8428PLGONZ SWEAT GRAY
56767 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts BLACK
57386 FILA FS3026 CREW WHITE
57387 FILA FS3026 CREW NAVY
57350 SUPPLIER BICOLOR LOGO CREW SWEAT ORANGE
57353 SUPPLIER MARBLE CREW SWEAT NAVY
57314 ZERO EVOKE Three Needles Sweat 【WHITE】
57343 ZERO EVOKE ZE Logo First Sweat 【WHITE×WHITE】
57344 ZERO EVOKE ZE Logo First Sweat 【BLACK×BLACK】
56640 PUNK DRUNKERS SAVESTARトレーナー - NAVY
56641 PUNK DRUNKERS 鮫人刺繍トレーナー - BLACK
56642 PUNK DRUNKERS 鮫人刺繍トレーナー - BLUE
56441 Subciety SWEAT-SERVER-WHITE
56442 Subciety SWEAT-SERVER-BLACK
56066 Subciety 2021 福袋 -NEW YEAR BAG-
57102 Zephyren 2021 NEW YEAR BAG
57251 ガリュウホンポ 子猫トレーナー
57205 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 WHITE
57204 RIP DESIGN WORXX 2021 Wホンダソウイチコラボトレーナー福袋 BLACK
57203 RIP DESIGN WORXX 2021 ダウンベスト福袋
56768 FOG ESSENTIALS Riflector Logo Crew Sweat Shirts WHITE
56769 FOG ESSENTIALS Solid Crew Sweat Shirts TAN
56750 SILLENT FROM ME 沈黙・秘密 -Loose Crew Sweat- WHITE
56599 MAGICAL MOSH MISFITS SUICIDAL TENDENCIES x MxMxM “MAGICAL MOSH TENDENCIES” SWEAT
56566 MUSIC SAVED MY LIFE (MSML) HEAVY WEIGHT BALLOON SWEAT BLACK
55989 ROLLING CRADLE ICEE SWEAT / PURPLE
55974 ANIMALIA AN20A-SW06 “BLACKFOOT” Big silhouette Crew Neck Sweat BLACK
55975 ANIMALIA AN20A-SW06 “BLACKFOOT” Big silhouette Crew Neck Sweat WHITE
56281 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT BLACK
56282 MUSIC SAVED MY LIFE (MSML) CUT OFF BIG SWEAT CHACOAL GRAY
56284 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT OFF WHITE
56286 MUSIC SAVED MY LIFE (MSML) SPLASH SWEAT ORANGE
54849 PUNK DRUNKERS ぱんくどの森トレーナー - BLACK
56224 TOY MACHINE TOYDIVISION PRINT SWEAT CREW - BLACK
56196 NOT COMMON SENSE BUTTERFLY FLEECE THREE QUARTER SLEEVE BLACK
56197 NOT COMMON SENSE BUTTERFLY FLEECE THREE QUARTER SLEEVE WHITE
56114 N.B.O. TIE-DYE COLORBLOCK HOODIE
56076 SLEEPING TABLET CAPSULE [ OVERSIZED CREW SWEAT ] RED
55026 Zephyren(ゼファレン)PEINTED SWEAT BLACK
55028 Zephyren(ゼファレン)PEINTED SWEAT MUSTARD
55913 MISHKA MAW200423 SWEAT BLACK
9862 KILL STAR CLOTHING MAGICK SWEATSHIRT [B]
9872 KILL STAR CLOTHING BATS SWEATSHIRT [B]
9891 KILL STAR CLOTHING GRUMPY SWEATSHIRT
9894 KILL STAR CLOTHING GOETIA SWEATSHIRT
11214 Iwrestledabearonce Late Crest Black/Heather Crew
11621 KILL STAR CLOTHING GET HIGH CREW [MULTI]
14325 ICECREAM CREWNECK ROYAL BLUE K820
14337 KILL STAR CLOTHING COBRA SWEATSHIRT [MULTI]
14524 KILL STAR CLOTHING COFFEE SWEATSHIRT [B]
14847 ICECREAM CONES&BONES SWET GREEN
15410 MEMPHIS MAY FIRE Skulls & Arrows Black Crewneck
15469 BLESS THE FALL Hollow Bodies Black Crewneck Sweats
15481 ATTILA Kings Black Crewneck
15499 MISHKA (ミシカ) Autopsy Vex Crew Neck
15662 ZEPHYREN (ゼファレン) SWEAT -VISIONARY- BLK
16717 ICECREAM ALL OVER POPSICLE BLUE
17945 KILL STAR CLOTHING RUNE SWEATSHIRT [GLOSS]
17947 KILL STAR CLOTHING SPACE GRASS SWEATSHIRT
18984 WE CAME AS ROMANS Varsity Custom Heather Grey Crew
19100 ATTILA Guilty Pleasure Black Crewneck
19891 KILL STAR CLOTHING KALI SWEATSHIRT [B]
20689 Subciety (サブサエティ) SWEAT S/S-FLAG- BLACK
20697 Subciety SWEAT-GLORIOUS- NAVY/WHITE
20699 Subciety SWEAT-CAMOUFLAGE SALOON- BLACK
21301 ROLLING CRADLE STONED SWEAT / Black
21410 FAMOUS STARS AND STRAPS RS ROCK VS RAP Crewneck
22007 ROLLING CRADLE Sotrm trooper Sweat BLK
22162 FAMOUS STARS AND STRAPS HONEYCOMB CREWNECK FLEECE
22228 REBEL8 Standard Issue Logo Crewneck
22402 KILL STAR CLOTHING Cult Sweatshirt
22404 KILL STAR CLOTHING(キルスター・クロージング) Idol Sweatshirt TIEDYE
22405 KILL STAR CLOTHING(キルスター・クロージング) Idol Sweatshirt
22830 PUNK DRUNKERS メッシュ切替トレーナー BLUE
22849 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / White
22850 ROLLING CRADLE UNREASONABLE MONSTER SWEAT / Black
23452 HER NAME IN BLOOD ダンベル・クルーネック WHITE
23776 KILL STAR CLOTHING (キルスター・クロージング) Club 27 Sweatshirt [B}
24409 KILL STAR CLOTHING (キルスター・クロージング) Boardgame Sweatshirt [B]
24521 STAY SICK CLOTHING New Script Black Crewneck
24655 NECK DEEP Hero Quest Black - Crewneck
25144 CITY LIGHTS Arrows Black - Crewneck Sweatshirt
25161 WE CAME AS ROMANS Cracked Hope Heather Grey - Crewneck
25380 BLACK SCALE REBEL SLAM CREWNECK BLK
25381 BLACK SCALE REBEL SLAM CREWNECK GRY
25749 Subciety SWEAT-GLORIOUS- BLACK-WHITE
26144 ARCHITECTS Daybreaker Crewneck
27377 DEEZ NUTS Bout It Sweatshirt
27445 BLACK SCALE LOCKDOWN CN GREY
27446 BLACK SCALE LOCKDOWN CN BLACK
27507 KILL STAR CLOTHING (キルスター・クロージング) Chill Out Sweatshirt [B]
27509 KILL STAR CLOTHING (キルスター・クロージング) Slumber Crop Sweatshirt [B]
27518 KILL STAR CLOTHING (キルスター・クロージング) Slay Sweatshirt [TIEDYE]
28219 REBEL8 WOMENS CONSPIRACY SHORT SLEEVE CREWNECK
28227 REBEL8 BOMB SQUAD EMBROIDERED BLACK CREWNECK
28745 BLACK SCALE BLVCK REBELS SWEATSHIRTS BLACK
30108 MISHKA (ミシカ) EAD END CREWNECK WHITE
33611 MISHKA (ミシカ) Lamour Keep Watch Crewneck
33781 ANIMALIA AN17U-SW01 ANCHOR Sweat S/S NAVY
35471 Zephyren (ゼファレン) PILE SWEAT -BEYOND- BLACK
35660 PANTERA 101 Proof Sweatshirts
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 395
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=395&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 395
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=395