iVelo.cz


SELECT 
 podnik.*,
 (
 
SELECT 
 count(*) 
 
FROM `vpress_velo_sazk_single_jezdec_all` as jezdec 
 
WHERE jezdec.`podnik_id`=podnik.`podnik_id`
 ) as jezdcu
 
FROM vpress_velo_sazk_single_podnik as podnik
 
WHERE 
 podnik.`podnik_show` = '1'
 AND podnik.`podnik_date_lock` >= NOW()
 AND YEAR(podnik.`podnik_date_lock`)=2012
 
 
ORDER BY podnik.`podnik_date_lock` ASC
Nastala chyba v tomto dotazu: 1