1064 - 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 '-9999, 9999' at line 48
select p.buy_lend,
p.products_shippingtime,
p.products_model,
p.products_ean,
p.products_isbn,
p.products_ismn,
pd.products_name,
p.products_id,
p.products_price,
m.manufacturers_name,
p.manufacturers_id,
p.editors_id,
p.products_quantity,
p.products_image,
p.products_weight,
p.products_sg,
p.products_kompjahr,
p.products_opus,
p.products_spieldauer,
p.products_cdnr,
pd.products_add_authors,
pd.products_incl_authors,
pd.products_description,
pd.products_subtitle2,
pd.products_subtitle1,
pd.products_addition2,
pd.products_addition1,
pd.products_type,
pd.products_cast,
pd.products_cast_general,
pd.products_series,
pd.products_parts,
pd.products_language,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_discount_allowed,
p.products_tax_class_id
from products_description pd, manufacturers m, products p left join specials s on p.products_id = s.products_id
where p.products_status = '1'
and pd.products_id = p.products_id
and p.group_permission_1=1
and pd.language_id = 2
and ( ( p.manufacturers_id = m.manufacturers_id ) or ( p.editors_id = m.manufacturers_id ) )
and m.manufacturers_id = '415' ORDER BY pd.products_name ASC LIMIT -9999, 9999
[XT SQL Error]