あいにょん
アマツカミ新作予約受付開始!

アイテム一覧

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 =62 )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-10-16 21:22:43') AND pc.price02 > 909 AND price02 <= 2727 AND pc.stock > 0 AND FIND_IN_SET(3, p.color) AND pc.del_flg = 0 GROUP BY p.product_id ORDER BY p.update_date DESC LIMIT 0, 120

4件見つかりました

1ページ中1ページ目


1,650

Zephyren
Accessory
フリー 残り1点

3,300
2,310

STAY SICK CLOTHING
Goods
フリー 残り1点

2,200
1,540

RIP DESIGN WORXX
Tumbler
フリー 残り1点

2,200
1,540

KEYTALK
Accessory

4件見つかりました

1ページ中1ページ目



32493 Zephyren(ゼファレン) NECK STRAP -VISIONARY- WHITE 28254 STAY SICK CLOTHING Old Glory Black/White Flag 41628 RIP DESIGN WORXX カフェタンブラー STANDARD WHITE 42600 KEYTALK 横アリ記念スタッキングマグカップ POST : Array ( ) -------- GET : Array ( [work] => new_arrival [cat] => 62 [price] => 1 [color] => 3 ) -------- $_SERVER['REQUEST_URI'] /new_arrival/&cat=62&price=1&color=3& -------- mb_parse_str Array ( [work] => new_arrival [cat] => 62 [price] => 1 [color] => 3 ) -------- $_SERVER['QUERY_STRING'] work=new_arrival&&cat=62&price=1&color=3