Pilsner Urquell

<-- 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` = 3) 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 (403,404,417,418,405,406,407,415) and `taa_eshop_zbozi`.`zobrazit_mo` = '1' and `taa_eshop_zbozi`.`mcena_s_dph` >= '79.0000' and `taa_eshop_zbozi`.`mcena_s_dph` <= '2390.0000' GROUP BY `taa_eshop_zbozi`.`id` ORDER BY FIELD(`id_k`,403,404,417,418,405,406,407,415) ASC, `taa_eshop_zbozi`.`poradi` DESC, `taa_eshop_zbozi`.`id` ASC LIMIT 0,24 //-->