ÜZLETI
SZAKNÉVSOR

Unable to execute your query. Please correct this error.
You may need to update your database structure.
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 'order by te1 desc, kszo desc, e.pozicio asc, e.vasarlas_datum_ido asc, c.legal_n' at line 2
I tried to execute:
select *, cid, CASE termek_id WHEN 3 THEN 1 WHEN 6 THEN 2 when 5 then 3 END as t2 from ( SELECT if(e.terulet LIKE(':28:'), '1','0') as te1 , b.sorszam as bsz, f.banner_id, f.file_name, f.elonezet_file_name, c.company_id cid, c.company_id, e.termek_id, e.pozicio as poz1, c.*, a.*, e.*, k.*, if(e.kulcsszavak LIKE('%%'), '1','0') as kszo FROM addresses a, eladas e, kozterulet k, companies c LEFT JOIN banners b ON c.company_id = b.c_id left join files f on b.sorszam = f.banner_id WHERE a.kozterulet = k.sorszam AND c.company_id = a.company_id AND a.type = 'C' AND c.company_id = e.company_id AND a.address_type = '0' AND c.jovahagyva = 'I' AND (e.termek_id = '5' OR e.termek_id = '6' OR e.termek_id = '3') AND order by te1 desc, kszo desc, e.pozicio asc, e.vasarlas_datum_ido asc, c.legal_name asc ) as belso order by kszo desc, te1 desc, poz1 asc, t2 asc
Fatal error: Call to a member function on a non-object in /var/www/html/crmadmin/kulso2/out.php on line 2444