select distinct f.firm_id as firm_id, f.fname as fname , f.street as street, f.house as house, f.tarif as tarif, f.zip as zip, f.dopinfo as dopinfo, f.firm_type as ftype, f.page as page, f.catalog as catalog, f.price as price, f.logo as logo, f.counter as counter,
c.cname as cname, c.code as code, r.rname as rname
from firms_kat k, city c, firms f LEFT JOIN region r ON f.rayon = r.r_id
where f.city = c.c_id and f.firm_id = k.firm_id and f.stat = '1'
AND k.categories_id=''
order by f.tarif DESC, f.fname LIMIT 0, 100 1: Can't create/write to file '/tmp/#sql-temptable-369-e0570-4ad.MAI' (Errcode: 28 "No space left on device") select distinct f.firm_id as firm_id, f.fname as fname , f.street as street, f.house as house, f.tarif as tarif, f.zip as zip, f.dopinfo as dopinfo, f.firm_type as ftype, f.page as page, f.catalog as catalog, f.price as price, f.logo as logo, f.counter as counter,
c.cname as cname, c.code as code, r.rname as rname
from firms_kat k, city c, firms f LEFT JOIN region r ON f.rayon = r.r_id
where f.city = c.c_id and f.firm_id = k.firm_id and f.stat = '1'
AND k.categories_id=''
order by RAND() LIMIT 10 1021: Disk got full writing '.(temporary)' (Errcode: 28 "No space left on device") Предприятия , бизнес объявления , желтые страницы , услуги и сайты компаний по городам России, Украины и Беларуси. Справочник предприятий "МирУслугИнфо"
Желтые страницы, бизнес-объявления, предприятия по городам России, Украины и Беларуси. Каталог предприятий МирУслугИнфо
Cоздать сайт предприятия
Архангельск 