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 =571
)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 >= '2022-05-23 13:49:05')
AND pc.stock > 0
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
63215 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - WHITE
63226 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - F.GREEN
63225 TOY MACHINE (トイマシーン) BIG PEPPER SECT EMBROIDERY SS POLO - BLACK
63216 TOY MACHINE (トイマシーン) OG MONSTER WORK SHIRTS - BLACK
63213 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BEIGE
63214 TOY MACHINE (トイマシーン) FIST WORK SHIRTS - BLACK
63266 【予約商品】GALFY (ガルフィー) 東名阪チームシャツ WHITE (中日)
63267 【予約商品】GALFY (ガルフィー) 東名阪チームシャツ WHITEst (阪神)
63268 【予約商品】GALFY (ガルフィー) 東名阪チームシャツ GRAY (巨人)
62198 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - GRAYⅠ
62200 Zephyren(ゼファレン) CHECK SHIRT S/S - Resolve - BURGUNDY
62212 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - WHITE
62214 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - FEAR NO ONE - PAISLEY
62228 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - BLACK / DRAGONFLY
62226 Zephyren(ゼファレン) BIG SHIRT S/S - Resolve - FLOWER
62207 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE / PAISLEY
62195 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK
57442 Zephyren(ゼファレン) EMBLEM SHIRT S/S MIX
63449 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS WHITE
63450 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS BLUE
63451 BAD BOY (バッドボーイ) BORDER BIG POLO SHIRTS GREEN
62208 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK / PAISLEY
62209 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - BLACK CHECK
57453 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - WHITE CHECK
57457 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - PAISLEY
16880 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - WHITE
63103 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT WHITE
63105 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLUE
63104 Subciety (サブサエティ) OPEN-COLLAR EMBLEM SHIRT BLACK
62152 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLACK
62153 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT BLUE
62154 Subciety (サブサエティ) BIG SILHOUETTE RUGGER SHIRT KHAKI
62655 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - BLACK
62656 PUNK DRUNKERS (パンクドランカーズ) ピースポロ - D.GREEN
60887 PUNK DRUNKERS [PDSx阪神タイガース]阪神ベースボールシャツ - BLACK
60886 PUNK DRUNKERS [PDSx阪神タイガース]阪神ベースボールシャツ - WHITE
62647 【予約商品】PUNK DRUNKERS ホラーアロハシャツ - WHITE
62648 【予約商品】PUNK DRUNKERS ホラーアロハシャツ - CHARCOAL
62653 【予約商品】PUNK DRUNKERS PDベースボールシャツ - BLACK
62654 【予約商品】PUNK DRUNKERS PDベースボールシャツ - BLUE
61925 【予約商品】glamb (グラム) Nixon Aloha SH - Black
62566 NineMicrophones CRAZY SHIRT BLACK/WHITE
62567 NineMicrophones CRAZY SHIRT MULTI
61504 NieR (ニーア) ARM ZIP付き2WAY LONG SHIRT【ネクタイ付き】
61094 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BROWN
61095 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS KHAKI
61096 VIRGO (ヴァルゴ) TRIBE WIDE SHIRTS BLACK
60156 Anti Social Social Club WOODY WHITE BUTTON UP
60159 Anti Social Social Club STATIC ORANGE BUTTON UP
60158 Anti Social Social Club STATIC BLACK BUTTON UP
60351 HYPER CORE O-181B Continue?ショートスリーブボタンシャツ
60131 HYPER CORE HCO-181 Cherry Frappuccino 半袖シャツ
60157 【予約商品】Anti Social Social Club WOODY BLACK BUTTON UP
58727 VIRGO VGW ALOHA SHIRTS RED
57920 Subciety (サブサエティ) WEEKENDER SHIRT - BLACK
57921 Subciety (サブサエティ) WEEKENDER SHIRT - BEIGE
57922 Subciety (サブサエティ) HALF ZIP CUBA SHIRT- BLACK
57463 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - BLACK / PAISLEY
59871 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 GRAY
59870 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 ORIVE
59869 PSYCHOLOGICAL METAMORPHOSIS CHINO WORK SHIRTS 2 YELLOW
58579 MISHKA(ミシカ) M21000204 S/S Shirt
57367 MISHKA M21000205 S/S Shirt
59846 HYPER CORE SICKS BEAR 2WAYワークシャツ
57437 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - WHITE
57443 Zephyren(ゼファレン) EMBLEM SHIRT S/S WHITE / You are hare
57461 Zephyren(ゼファレン) PHOTO PRINT SHIRT S/S - NEVER say NEVER - WHITE
57458 Zephyren(ゼファレン) LONG SHIRT S/S - Resolve - FLOWER
59246 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLACK
59247 ANIMALIA AN21U-SH02 BIG DOLMAN SHIRTS - Dungaree BLUE
59220 LONELY論理 LONELISM SHIRTS white
59221 LONELY論理 LONELISM SHIRTS black
58438 HEDWiNG Neon Totalhandle Shirt Black
58779 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
58786 TOY MACHINE (トイマシーン) PRINT SHIRTS BLACK
57439 Zephyren(ゼファレン) BOWLING SHIRT- ビレッジマンズストア × Zephyren - BURGUNDY
57444 Zephyren(ゼファレン) EMBLEM SHIRT S/S BLACK / You are hare
54765 PSYCHOLOGICAL METAMORPHOSIS PMLP WORK SHIRTS RED
48409 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF WHITE
8152 Subciety EMBLEM SHIRT S/S-Plain- WHITE
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
55648 THRASHER (スラッシャー) TH5179 S/S WORK SHIRT WHITE
53231 Zephyren(ゼファレン)SWITCHING SHIRT S/S BLACK
16882 ZEPHYREN (ゼファレン) EMBLEM SHIRT S/S - BLACK
52765 Subciety PAISLEY DROP SHOULDER SHIRT NAVY
52764 Subciety PAISLEY DROP SHOULDER SHIRT BLACK
52761 Subciety MARIA WORK SHIRT WHITE
22967 Subciety EMBLEM SHIRT S/S YELLOW
22968 Subciety EMBLEM SHIRT S/S PINK
23004 Subciety ALOHA SHIRT S/S NAVY
23014 Subciety EMBLEM WORK SHIRT S/S-CHAMBRAY- BLUE
23021 Subciety OMBRE CHECK SHIRT S/S-THRON- MUSTARD
23022 Subciety OMBRE CHECK SHIRT S/S-THRON- RED
24962 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- GREEN
24963 Subciety (サブサエティ) EMBLEM SHIRT S/S-CAMOUFLAGE- BEIGE
24964 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- WHITE
24966 Subciety (サブサエティ) EMBROIDERY SHIRT S/S-GLORIOUS- OD
29187 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- BLUE
29188 Subciety (サブサエティ) EMBLEM SHIRT S/S-CHECK- YELLOW
32632 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF-WHITE
39582 Subciety MULTI CAMO SHIRT S/S
39586 Subciety CHECK SHIRT GREEN
39587 Subciety CHECK SHIRT NAVY
47515 Subciety WORK SHIRT S/S-Basjoe- GRAY
47517 Subciety WORK SHIRT S/S-Basjoe- NAVY
47860 Subciety (サブサエティ) CHECK SHIRTS-BABYLON- RED
54747 Dezzn Savior Shirt BLACK
7511 DROP DEAD CLOTHING LEOVEPARD TOP
10070 MISHKA (ミシカ) ANIMAL PARADE BUTTON UP STORMY BLACK
10071 MISHKA (ミシカ) TERRITORY BUTTON UP WHITE
11059 VANS APPAREL RUSDEN IKAT S/S SHIRT LIVING CORAL
11062 VANS APPAREL CHECKED OUT S/S WOVEN SHIRT RED
11097 MISHKA (ミシカ) THE HELLA STUFF S/S BUTTONDOWN WHITE
15292 REBEL8 WOMENS WATCH YOUR STEP BUTTON-UP
15758 MISHKA (ミシカ) Crypt Keeper Button Up Shirt
20011 ROLLING CRADLE FUCK×FUCK SHIRT / White
23613 Zephyren (ゼファレン) EMBLEM SHIRT S/S CAMO II
23973 ANIMALIA AN16U-SH03 BOUND PRISONER #001 GRAY
23976 ANIMALIA AN16U-SH04 SWAGGER #003 BLACK
24727 Zephyren (ゼファレン) BLOCK STRIPE SHIRT S/S -Charmed SQ Tone- RED
POST :
Array
(
)
--------
GET :
Array
(
[work] => new_arrival
[cat] => 571
)
--------
$_SERVER['REQUEST_URI']
/new_arrival/&cat=571&
--------
mb_parse_str
Array
(
[work] => new_arrival
[cat] => 571
)
--------
$_SERVER['QUERY_STRING']
work=new_arrival&&cat=571