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 dtb_products AS p
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-01-22 16:40:18')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 77)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
57277 【予約商品】Subciety PARKA-PROVIDENCE- BLACK
57278 【予約商品】Subciety PARKA-PROVIDENCE- GRAY
57279 【予約商品】Subciety PARKA-PROVIDENCE- NAVY
56401 Subciety SNAP BACK CAP-SERVER- BLACK/WHITE
56385 Subciety BEANIE-SERVER - BLACK
56454 Subciety BREAK PARKA- BLACK
56455 Subciety BREAK PARKA- YELLOW
56829 Subcietyx攻殻機動隊 CONNECT PARKA BLACK
56830 Subcietyx攻殻機動隊 SECTION9 PARKA BLACK
56831 Subcietyx攻殻機動隊 Cyberbrain L/S BLACK
56832 Subcietyx攻殻機動隊 TACHIKOMA L/S WHITE
56833 Subcietyx攻殻機動隊 SECTION9 PARKA GRAY
56834 Subcietyx攻殻機動隊 CONNECT PARKA GRAY
56835 Subcietyx攻殻機動隊 TACHIKOMA L/S BLUE
56836 Subcietyx攻殻機動隊 SECTION9 PARKA KHAKI
56837 Subcietyx攻殻機動隊 CONNECT PARKA KHAKI
56838 Subcietyx攻殻機動隊 TACHIKOMA L/S BLACK
56839 Subcietyx攻殻機動隊 Cyberbrain L/S PURPLE
56841 Subcietyx攻殻機動隊 Cyberbrain L/S WHITE
56441 Subciety SWEAT-SERVER-WHITE
56442 Subciety SWEAT-SERVER-BLACK
55776 【バンドリ!×ゲキクロ 第2弾復刻】Subciety×氷川紗夜コラボ 限定 パーカー
55775 【バンドリ!×ゲキクロ 第2弾復刻】Subciety×氷川紗夜コラボ 限定 L/S Tシャツ
55774 【バンドリ!×ゲキクロ 第2弾復刻】Subciety×氷川紗夜コラボ 限定 ニットキャップ
54234 Subciety BANDANA QUILTING JKT BLACK/RED
54235 Subciety BANDANA QUILTING JKT BLACK/NAVY
54238 Subciety DOWN JKT BLACK
54264 Subciety A-2PARKA BLACK
54266 Subciety A-2PARKA BEIGE
56514 Subciety DOWN MUFFLER BLACK
56292 Subciety (サブサエティ) TROOPER HAT BLACK
56293 Subciety (サブサエティ) TROOPER HAT ORANGE
54325 Subciety Purgatory L/S BLACK
54339 Subciety(サブサエティ) BEANIE ORANGE
54340 Subciety(サブサエティ) BEANIE YELLOW
54345 Subciety(サブサエティ) LEOPARD SLACKS BLACK
54346 Subciety(サブサエティ) LEOPARD SLACKS BEIGE
54273 Subciety PAISLEY SHIIRT BLACK
54276 Subciety PANEL SHIRT BLACK/BLACK
54279 Subciety WORK SHIRT BLACK
54242 Subciety MIDDLE LOGO PARKA IVORY
54244 Subciety MIDDLE LOGO PARKA KHAKI
50668 Subciety (サブサエティ) SPORT JACKET BLACK
54227 Subciety LEOPARD SWING TOP BLACK
54228 Subciety LEOPARD SWING TOP BEIGE
56021 Subciety (サブサエティ) HALF ZIP BOA PARKA CAMEL
14639 Subciety PARKA-GLORIOUS- BLACK/WHITE
20657 Subciety (サブサエティ) EMBLEM SHIRT L/S-STRIPE- OFF WHITE
34665 Subciety (サブサエティ) EMBLEM SHIRT L/S-STRIPE- NAVY
3039 Subciety EMBLEM SHIRT L/S-Plain- BLACK
5938 Subciety EMBLEM SHIRT L/S-Plain- WHITE
39638 Subciety WORK PANTS-PAISLEY- BLACK
39639 Subciety WORK PANTS-PAISLEY- BEIGE
56006 Subciety (サブサエティ) NEON SOCKS ORANGE
56007 Subciety (サブサエティ) NEON SOCKS YELLOW
56008 Subciety (サブサエティ) NEON SOCKS GREEN
54225 Subciety COACH JKT-MIDDLE LOGO- BLACK
55834 Subciety liquid S/S BLACK
52875 【バンドリ!×ゲキクロ 第5弾】Subciety×瀬田 薫コラボ 限定 L/S シャツ
52876 【バンドリ!×ゲキクロ 第5弾】Subciety×瀬田 薫コラボ 限定 Tシャツ
52877 【バンドリ!×ゲキクロ 第5弾】Subciety×瀬田 薫コラボ 限定 ベルト
54526 【バンドリ!×ゲキクロ第1弾復刻】Subciety×氷川紗夜コラボ 限定 Tシャツ
48409 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- OFF WHITE
48408 Subciety (サブサエティ) EMBLEM SHIRT S/S-STRIPE- NAVY
8152 Subciety EMBLEM SHIRT S/S-Plain- WHITE
1581 Subciety EMBLEM SHIRT S/S-Plain- BLACK
18451 Subciety THE BASE S/S - WHITE
18452 Subciety THE BASE S/S - BLACK/WHITE
47820 Subciety SNAP BACK CAP-THE BASE- BLACK/WHITE
47822 Subciety SNAP BACK CAP -GLORIOUS- BLACK/WHITE
54183 Subcietyx攻殻機動隊SAC_2045 GHOST HACK L/S WHITE
54186 Subcietyx攻殻機動隊SAC_2045 Major S/S WHITE
54187 Subcietyx攻殻機動隊SAC_2045 Major S/S BLACK
54190 Subcietyx攻殻機動隊SAC_2045 Ghost in the Subciety S/S BLACK
52805 Subciety MULTI BORDER L/S PINK
52806 Subciety MULTI BORDER L/S BLUE
52780 Subciety $??¥ S/S GREEN
53022 Subciety Daisy S/S WHITE
53021 Subciety Daisy S/S BLACK
52791 Subciety PYTHON S/S BLACK
52799 Subciety EMBROIDERY THE BASE TEE GRAY
52798 Subciety EMBROIDERY THE BASE TEE BLACK
52797 Subciety EMBROIDERY THE BASE TEE WHITE
18445 Subciety GLORIOUS S/S - WHITE/BLACK
18447 Subciety GLORIOUS S/S - BLACK/WHITE
52765 Subciety PAISLEY DROP SHOULDER SHIRT NAVY
52764 Subciety PAISLEY DROP SHOULDER SHIRT BLACK
52762 Subciety MARIA WORK SHIRT BLACK
52761 Subciety MARIA WORK SHIRT WHITE
52807 Subciety PYTHON CARGO SHORTS BLACK
52810 Subciety WIDE SLACKSBEIGE
52809 Subciety WIDE SLACKS BLACK
52821 Subciety LOW CAP ORANGE
52847 Subciety GYM SOCKS WHITE/BLUE
52830 Subciety CAUCHO BELT NAVY/GREEN
52829 Subciety CAUCHO BELT NAVY/BURGUNDY
52828 Subciety CAUCHO BELT BLACK
52851 Subciety AIRPODS CASE BLACK
53023 Subciety EMOTION S/S BLACK
53025 Subciety Guadalupe S/S BLACK
53027 Subciety RATIO S/S BLACK
53028 Subciety RATIO S/S WHITE
50952 Subciety (サブサエティ) DROP SHOULDER TEE-TAG- BLACK
50953 Subciety (サブサエティ) EMBROIDERY TEE BK/WHT
50955 Subciety (サブサエティ) EMBROIDERY TEE BLACK/RED
47434 Subciety SIDE GLORIOUS S/S WHITE
48288 Subciety (サブサエティ) SUKA SOUVENIR S/S WHITE
48289 Subciety (サブサエティ) SUKA SOUVENIR S/S BLACK
42883 Subciety THE BASE S/S - MAGENTA/WHITE
42882 Subciety THE BASE S/S - ORANGE/WHITE
42890 Subciety GLORIOUS S/S - PURPLE/WHITE
41436 Subciety (サブサエティ) BRAND S/S BLACK
12479 Subciety TIE DYE TEE S/S GRAY
45736 Subciety (サブサエティ) BABYLON TEE WHITE
45737 Subciety (サブサエティ) BABYLON TEE BLACK
25771 Subciety STANDARD S/S BLACK
34686 Subciety (サブサエティ) TAG S/S WHITE
38026 Subciety (サブサエティ) ザ・ベース S/S WHITE
20756 Subciety POCKET TEE S/S-GLORIOUS- WHITE
20757 Subciety POCKET TEE S/S-GLORIOUS- BLACK
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => subciety
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/subciety/
--------
mb_parse_str
Array
(
[brand_name] => subciety
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=subciety&/