|
|
|
|
|
|
Fatal error:
SELECT
l.state as link_state,
c.category_name,
c.uid as category,
c.is_opened,
p.uid, p.Simg, p.product_name, p.product_code,p.is_option,p.is_discount,p.send_area,p.flag,p.serialized,p.md_img_type,p.md_img_code,
p.sp_price, p.sp_sale_price, p.hi_price, p.hi_sale_price,p.default_img,
p.sp_milage, p.hi_milage, p.no_milage,
p.no_price, p.no_sale_price, p.reserve_icon
FROM
sf_products_link l
LEFT JOIN sf_category c ON l.category_uid=c.uid
LEFT JOIN sf_products p ON l.product_uid=p.uid
WHERE
(l.category_uid>=30700 AND l.category_uid<30800) AND
p.is_opened='1' AND
p.is_discount!='2'
group by
l.product_uid
order by
p.createdate DESC
LIMIT
100,-80
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-80' at line 23 in /home/sflower.web/public_html/common/mysql.php on line 118
| |