(173) Unknown column 's' in 'order clause' SELECT
sp.dir,
sp.p_id,
sp.status,
sp.p_name,
sp.p_maker,
sp.bigo,
sp.p_price2,
sp.p_point,
sp.p_price,
sp.p_price_L1,
sp.p_price_L2,
sp.p_price_L3,
sp.special,
sp.size_l,
sm.id AS maker_id
FROM
shop_dir sd,
shop_product sp LEFT JOIN shop_maker sm ON sp.p_maker = sm.name
WHERE
sd.hidden != 'yes' AND sd.real_name != 'yes' AND
sd.link LIKE '1-671-1047-%' AND
sd.dir = sp.dir AND
sp.status != 'ÆǸŴë±â'
ORDER BY sp.p_maker asc,sp.p_name asc,s
LIMIT 0,999
|
|
|