---

Error - sql = SELECT * FROM zapchasti_catList,zapchasti_productList,zapchasti_toProduct WHERE zapchasti_catList.idCat = zapchasti_productList.idCat AND zapchasti_productList.idMarka = 87 AND zapchasti_productList.idProduct = zapchasti_toProduct.idProduct AND zapchasti_toProduct.id IN ( SELECT DISTINCT zapchasti_toType.id FROM zapchasti_toType WHERE zapchasti_toType.idType = 10 ) ORDER by zapchasti_catList.titleCat ASC

---

---

Error - sql = SELECT zapchasti_model.kod as kod, zapchasti_model.sklad as sklad, zapchasti_model.id as id, zapchasti_model.countProdag as countProdag, zapchasti_model.countProdag4 as countProdag4, zapchasti_model.countProdag8 as countProdag8, zapchasti_model.countProdag7 as countProdag7, zapchasti_model.titleZapchast as titleZapchast, zapchasti_model.titleZapchastUA as titleZapchastUA, zapchasti_model.dateCreate as dateCreate, zapchasti_model.ostatok as ostatok, zapchasti_model.dateOstatok as dateOstatok, zapchasti_model.kopisZapchast as kopisZapchast, zapchasti_model.kopisZapchastUA as kopisZapchastUA, zapchasti_model.textZapchast as textZapchast, min(zapchasti_price.cenaOut) as cenaOut, zapchasti_price.kodPrice as kodPrice, zapchasti_price.valuta as valuta, zapchasti_price.datePrice as datePrice, zapchasti_price.idImporter as idImporter, zapchasti_price.cenaIn as cenaIn, zapchasti_price.idPrice as idPrice, zapchasti_toType.idType as idType FROM zapchasti_model LEFT JOIN zapchasti_price ON zapchasti_model.id = zapchasti_price.id LEFT JOIN zapchasti_toType ON zapchasti_model.id = zapchasti_toType.id WHERE zapchasti_model.id IN (SELECT DISTINCT zapchasti_toProduct.id FROM zapchasti_toProduct RIGHT JOIN zapchasti_toType ON zapchasti_toProduct.id = zapchasti_toType.id LEFT JOIN zapchasti_productList ON zapchasti_toProduct.idProduct = zapchasti_productList.idProduct WHERE zapchasti_productList.idCat = 8 AND zapchasti_productList.idMarka = 87 AND zapchasti_toType.idType = 10 ) AND (zapchasti_model.ostatok > 0 OR (zapchasti_model.ostatok = 0 AND (1772777651 - zapchasti_model.dayOstatok) < 172800) ) GROUP by zapchasti_model.id Order by zapchasti_model.countProdag8 DESC

---