FATAL ERROR: 42000 1064 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 ')
AND t.`name` NOT LIKE 'Закупка на основе контракта%'
A' at line 20 SELECT
t.id,
t.`type`,
t.`name`,
ROUND(t.price) AS price,
t.publicationDate,
IF(t.finishDocDate, t.finishDocDate, IF(t.startDocDate, ADDDATE(t.startDocDate, 10), ADDDATE(t.publicationDate, 10))) AS finishDocDate,
p.`name` AS placementname,
p.url AS placementurl,
(SELECT o.fullName FROM Lot l JOIN CustomerLot cl ON cl.lotId = l.id JOIN Organization o ON o.id = cl.organizationId WHERE tenderId = t.id LIMIT 1) AS customerfullName,
(SELECT r.name FROM CityTender ct JOIN Region r ON r.id = ct.cityId where ct.tenderId = t.id LIMIT 1) as customerCity,
(SELECT rt.regionId FROM RegionTender rt WHERE rt.tenderId = t.id LIMIT 1) AS regionid,
(SELECT r.name FROM RegionTender rt JOIN Region r ON r.id = rt.regionId WHERE rt.tenderId = t.id LIMIT 1) as regionName,
(SELECT GROUP_CONCAT(ct.cityId, ":", r.name SEPARATOR ";") FROM CityTender ct JOIN Region r ON r.id = ct.cityId WHERE ct.tenderId = t.id) as allCity,
(SELECT st.subcategoryId FROM SubcategoryTender st WHERE st.tenderId = t.id LIMIT 1) AS categoryid,
IF(EXISTS (SELECT * FROM Protocol p WHERE p.tenderId = t.id), 1, 0) AS has_protocol,
IF(EXISTS (SELECT * FROM Contract c WHERE c.tenderId = t.id), 1, 0) AS has_contract
FROM Tender t
LEFT JOIN Placement p ON p.id = t.placementId
WHERE t.id IN ()
AND t.`name` NOT LIKE 'Закупка на основе контракта%'
AND t.`name` NOT LIKE 'Закупка товара у единственного поставщика%'
В системе Инитпро не найдены тендеры по выбранной категории.
Выберите другую категорию или регион.