!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 ')
order by zbozi_nazev limit 8' at line 7!
select *
,(select zbozi_cena from zbozi as z where z.zbozi_parent=zbozi.zbozi_id order by zbozi_cena limit 1) as cena_low
from zbozi
left join zbozi2kat on zbozi2kat_zbozi=zbozi_id
left join shozna on shozna_id=zbozi_znacka
left join shoakce on shoakce_id=zbozi_akce
where zbozi2kat_kategorie in (1,2,3,4,116,115,12,13,14,39,29,30,58,60,61,68,69,72,77,78,79,80,114,86,87,88,89,91,103,107,108,111,112,113,)
order by zbozi_nazev limit 8
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/www.vinoteka-benesov.cz/__framework/function.php on line 225
!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 ')
group by shozna_id limit 8' at line 4!
select shozna_id,shozna_znacka from zbozi
left join zbozi2kat on zbozi2kat_zbozi=zbozi_id
left join shozna on shozna_id=zbozi_znacka
where zbozi2kat_kategorie in (1,2,3,4,116,115,12,13,14,39,29,30,58,60,61,68,69,72,77,78,79,80,114,86,87,88,89,91,103,107,108,111,112,113,)
group by shozna_id limit 8
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/www.vinoteka-benesov.cz/__framework/function.php on line 225
!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 ')
group by zbozi_nazev order by zbozi_nazev' at line 3!
select * from zbozi
left join zbozi2kat on zbozi2kat_zbozi=zbozi_id
where zbozi2kat_kategorie in (1,2,3,4,116,115,12,13,14,39,29,30,58,60,61,68,69,72,77,78,79,80,114,86,87,88,89,91,103,107,108,111,112,113,)
group by zbozi_nazev order by zbozi_nazev
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/www.vinoteka-benesov.cz/__framework/function.php on line 225
!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 ')
group by shozna_id' at line 4!
select shozna_id,shozna_znacka from zbozi
left join zbozi2kat on zbozi2kat_zbozi=zbozi_id
left join shozna on shozna_id=zbozi_znacka
where zbozi2kat_kategorie in (1,2,3,4,116,115,12,13,14,39,29,30,58,60,61,68,69,72,77,78,79,80,114,86,87,88,89,91,103,107,108,111,112,113,)
group by shozna_id
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/www.vinoteka-benesov.cz/__framework/function.php on line 225