<-- SELECT `taa_eshop_zbozi`.*, `taa_eshop_zbozi_lang`.* FROM `taa_eshop_zbozi` INNER JOIN `taa_eshop_zbozi_lang` ON (`taa_eshop_zbozi`.`id` = `taa_eshop_zbozi_lang`.`id_p` and `taa_eshop_zbozi_lang`.`id_lang` = 2) INNER JOIN `taa_eshop_katalog` ON (`taa_eshop_zbozi`.`id` = `taa_eshop_katalog`.`id_p`) WHERE `taa_eshop_zbozi_lang`.`nazev` IS NOT NULL and `taa_eshop_zbozi_lang`.`nazev` != '' and `taa_eshop_zbozi`.`delete` = 0 and `taa_eshop_katalog`.`id_k` IN (16) and `taa_eshop_zbozi`.`zobrazit_mo` = '1' and `taa_eshop_zbozi`.`mcena_s_dph` >= '159.0000' and `taa_eshop_zbozi`.`mcena_s_dph` <= '205.0000' GROUP BY `taa_eshop_zbozi`.`id` ORDER BY FIELD(`id_k`,16) ASC, `taa_eshop_zbozi`.`poradi` DESC, `taa_eshop_zbozi`.`id` ASC LIMIT 0,24 //-->
