Инитпро | тендеры

Транкинговая связь – оборудование, услуги
Возможно, вы искали:
Рекомендуемые категории:
Челябинская область

Тендеры на транкинговую связь – оборудование, услуги Челябинской области

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 'Закупка товара у единственного поставщика%'

В системе Инитпро не найдены тендеры по выбранной категории.
Выберите другую категорию или регион.