VIOD - Vzdělávací institut ochrany dětí
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
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
SELECT l.*
FROM `viod__logos_project` AS lp
LEFT JOIN `viod__logos` AS l
ON lp.`vl_id`=l.`vl_id`
WHERE lp.`nav_id`=
ORDER BY lp.`vlp_order`
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
(c) VIOD 2010 | webhosting webdomena.cz