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 >= '2022-05-19 04:03:08')
AND pc.stock > 0
AND p.product_id IN (SELECT product_id FROM dtb_product_categories WHERE category_id = 804)
AND pc.del_flg = 0
GROUP BY p.product_id
ORDER BY p.update_date DESC
LIMIT 0, 120
18件見つかりました
1ページ中1ページ目
1
¥7,480
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
¥7,700
AFFECTER
Sweatshirt
¥3,080
AFFECTER
Cap
¥3,080
AFFECTER
Cap
¥3,080
AFFECTER
Cap
¥8,030
AFFECTER
Pullover
¥8,030
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
¥7,480
AFFECTER
Pullover
L 残り1点
¥8,580
AFFECTER
Sweatshirt
フリー 残り1点
¥4,180
AFFECTER
Hat
¥4,180
AFFECTER
Hat
¥4,180
AFFECTER
Hat
¥4,180
AFFECTER
Hat
¥4,180
AFFECTER
Hat
18件見つかりました
1ページ中1ページ目
1
61153 AFFECTER (アフェクター) LIGHTNING HOODIE BLACK
61154 AFFECTER (アフェクター) LIGHTNING HOODIE GREEN
61155 AFFECTER (アフェクター) AFF TM HOODIE BLACK
61156 AFFECTER (アフェクター) AFF TM HOODIE NAVY
61157 AFFECTER (アフェクター) OIL CREWNECK BLACK
61164 AFFECTER (アフェクター) LOGO CAP BLACK
61165 AFFECTER (アフェクター) LOGO CAP L.BEIGE
61166 AFFECTER (アフェクター) LOGO CAP NAVY
61149 AFFECTER (アフェクター) NESS HOODIE BLACK
61150 AFFECTER (アフェクター) NESS HOODIE GREEN
61151 AFFECTER (アフェクター) TAG HOODIE BLACK
61152 AFFECTER (アフェクター) TAG HOODIE GRAY
61158 AFFECTER (アフェクター) AF BIG CREW
61159 AFFECTER (アフェクター) TM BUCKET HAT BLACK
61160 AFFECTER (アフェクター) TM BUCKET HAT OLIVE
61161 AFFECTER (アフェクター) TM BUCKET HAT NAVY
61162 AFFECTER (アフェクター) AFF DENIM HAT GRAY
61163 AFFECTER (アフェクター) AFF DENIM HAT BLUE
POST :
Array
(
)
--------
GET :
Array
(
[brand_name] => affecter
[/] =>
)
--------
$_SERVER['REQUEST_URI']
/brand/affecter/
--------
mb_parse_str
Array
(
[brand_name] => affecter
[/] =>
)
--------
$_SERVER['QUERY_STRING']
brand_name=affecter&/