Wystapil blad podczas wykonywania zapytania SQL!
MySQL query:
SELECT Drzewko.lvl, Drzewko.DIDKategorii, oferta_kategorie.NazwaKategorii FROM (SELECT @r AS DIDKategorii,
(
SELECT @r := IDRodzica
FROM oferta_kategorie
WHERE IDKategorii = DIDKategorii
) AS IDRodzica,
@l := @l + 1 AS lvl
FROM (
SELECT @r := ,
@l := 0,
@cl := 0
) vars,
oferta_kategorie h
WHERE @r <> 0) AS Drzewko
LEFT JOIN oferta_kategorie ON Drzewko.DIDKategorii = oferta_kategorie.IDKategorii
ORDER BY lvl ASC
MySQL zwrócił: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
@l := 0,
@cl := 0
) vars,
...' at line 9