2024-05-06 05: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 '3939')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