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

Все категории
Возможно, вы искали:
Рекомендуемые категории:
Агинское

Тендеры Агинского

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.id IN ( SELECT ct.tenderId FROM CityTender ct WHERE ct.cityId IN ( 1068 ' at line 22 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, (SELECT f.`text` FROM Fragment f WHERE f.tenderId = t.id AND f.subcategoryId = 0 LIMIT 1) AS fragment, (SELECT f.`text` FROM Fragment f WHERE f.tenderId = t.id LIMIT 1) AS any_fragment, 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.id IN ( SELECT ct.tenderId FROM CityTender ct WHERE ct.cityId IN ( 1068 ) )

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