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 f.city = '74' AND k.categories_id='5244'
order by f.tarif DESC, f.fname LIMIT 0, 100 1146: Table 'b27993_miruslug.firms_kat' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u27993/miruslug.info/www/abgtpl.php on line 331 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='5244'
order by RAND() LIMIT 10 1146: Table 'b27993_miruslug.firms_kat' doesn't exist
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/u27993/miruslug.info/www/abgtpl.php on line 331 Телевизионное оборудование. Екатеринбург. Справочник предприятий "МирУслугИнфо"
Екатеринбург. Желтые страницы, бизнес-объявления, предприятия Екатеринбурга. Каталог предприятий МирУслугИнфо