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 lp.`vlp_order`' at line 6

VIOD - Vzdělávací institut ochrany dětí - Archív/AGIS/Semina?e

VIOD - Vzdělávací institut ochrany dětí

Logo VIOD

Semin?e

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 'AND s.`vs_title_cz` != '' AND DATE_ADD(p.`vp_starttime`, INTERVAL 1 DAY)>NOW(' at line 14
SELECT s.`vs_id`, s.`vs_title_cz` AS vs_title, s.`vs_description_cz` AS vs_description, CONCAT(l.`vle_title`,' ',l.`vle_name`,' ',l.`vle_surname`) AS name FROM `viod__seminars_projects` AS sp LEFT JOIN `viod__seminars` AS s ON s.`vs_id`=sp.`vs_id` LEFT JOIN `viod__lectors` AS l ON s.`vle_id`=l.`vle_id` LEFT JOIN `viod__seminars_programs` AS sps ON s.`vs_id`=sps.`vs_id` LEFT JOIN `viod__programs` AS p ON p.`vp_id`=sps.`vp_id` WHERE sp.`nav_id`= AND s.`vs_title_cz` != '' AND DATE_ADD(p.`vp_starttime`, INTERVAL 1 DAY)>NOW() ORDER BY s.`vs_title_cz`

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 'AND s.`vs_title_cz` != '' AND DATE_ADD(p.`vp_starttime`, INTERVAL 1 DAY)>NOW(' at line 14

 

(c) VIOD 2010  |  webhosting webdomena.cz | Děkujeme Spravne-firmě.cz