2024-05-17 09:25:01 MySQL error:
Server shutdown in progress
Query:
/*nalog*/SELECT Tovar.NamePure,Tovar.kodTov,Tovar.kodName,Tovar.NameTov,IFNULL(OstatokAkt.Ost,0), IFNULL(OstatokAkt.CenaMin,0), IFNULL(OstatokAkt.CenaMax,0), IF(OstatokAkt.Ost>0,0,1)
FROM Tovar,OstatokAkt
WHERE (Tovar.KodTov=OstatokAkt.KodTov)AND(Tovar.KodMNN LIKE '29')AND(Tovar.NamePure!='Линкомицина')
GROUP BY Tovar.KodTov
ORDER BY Tovar.NamePure ASC,IF(OstatokAkt.Ost>0,0,1) ASC
SELECT Tovar.KodTov FROM Tovar WHERE NamePure = 'Линкомицина' LIMIT 0 , 1