Dotaz: SELECT * , (
SELECT IF(cena1 > 0 OR cena2 > 0 OR cena3 > 0, 1, 0)
FROM cenik
WHERE polozka = polozky.id
AND partner =
ORDER BY datum DESC
LIMIT 1
) AS cena
, (
SELECT bez_dopravy
FROM cenik
WHERE polozka = polozky.id
AND partner =
ORDER BY datum DESC
LIMIT 1
) AS bez_dopravy
, (
SELECT bez_skladani
FROM cenik
WHERE polozka = polozky.id
AND partner =
ORDER BY datum DESC
LIMIT 1
) AS bez_skladani
FROM polozky
WHERE pouzestav = 1
ORDER BY polozky.id
Chyba: 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 datum DESC
LIMIT 1
) AS cena
, (
SELECT bez_dopravy
FROM ceni' at line 6
SQL error: 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 datum DESC
LIMIT 1
) AS cena
, (
SELECT bez_dopravy
FROM ceni' at line 6.
