Регистрация Войти

Результаты поиска

Показаны первые 100 результатов при поиске по названию.
Если искомое лицо отсутствует в данном списке, пожалуйста, уточните реквизиты поиска.

[1] Can't create/write to file '/tmp/#sql_38cb_0.MYI' (Errcode: 28 - No space left on device) for query
/* uid = pctf9rq9d708ajadepr40le8l3 */SELECT `OGRN`, `DATE`, `TYPE`, CONCAT(`SEARCH`, ' ', `SEARCH_TWO`) as `SEARCH`, `SORT` FROM an_search WHERE (MATCH (SEARCH, SEARCH_TWO) AGAINST ('0101002300' IN BOOLEAN MODE)) UNION SELECT `COMPANY_OGRN` as `OGRN`, `DATE`, 'founder' as `TYPE`, CONCAT(`F`, ' ', `I`, ' ', `O`, ' ', `INN`) as SEARCH, -1 as `SORT` FROM an_founder_fio WHERE (MATCH (F, I, O) AGAINST ('0101002300' IN BOOLEAN MODE)) UNION SELECT `COMPANY_OGRN` as `OGRN`, `DATE`, 'founder' as `TYPE`, CONCAT(`F`, ' ', `I`, ' ', `O`, ' ', `INN`) as SEARCH, 10 as `SORT` FROM an_founder_fio WHERE INN IN (0101002300) GROUP BY `OGRN` ORDER BY `SORT` DESC, `DATE` DESC LIMIT 100;