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 'asc limit 15' at line 15
select distinct p.kod_lotniska_wylotu,op.logo,p.dlugosc_wycieczki,p.dlugosc_wycieczki2,p.manufacturers_id,p.products_id, p.products_image, p.products_tax_class_id, cd.categories_name as country,p.data_wylotu,
m.standard,m.manufacturers_name as manufacturers_name,m.hotel_code,p.products_price2 as products_price2, p.products_price as products_price
from products as p,
tour_operator as op,
manufacturers as m,
categories_description as cd,
products_to_categories p2c, categories c
where p.products_id = p2c.products_id
and p2c.categories_id = c.categories_id
AND cd.categories_id = m.country
AND op.id_operator=p.tour_operator_id
and p.manufacturers_id = m.manufacturers_id
and c.parent_id = '1637'
and p.products_status = '1'
order by p.products_price desc asc limit 15
[TEP STOP]
|
