CREATE TABLE IF NOT EXISTS `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `official_name` varchar(250) NOT NULL,
  `public_name` varchar(250) DEFAULT NULL,
...
  PRIMARY KEY (`id`),
  KEY `priority` (`priority`),
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` varchar(11) NOT NULL DEFAULT '0',
  `val` varchar(200) NOT NULL,
  `fk_parent` int(11) NOT NULL DEFAULT '0',
...
  PRIMARY KEY (`id`),
  KEY `val` (`val`),
  KEY `num` (`num`),
  KEY `url` (`url`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `tag2comp` (
  `fk_company` int(11) NOT NULL,
  `fk_tag` int(11) NOT NULL,
  `local_weight` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `comp_tag` (`fk_company`,`fk_tag`),
  KEY `fk_tag` (`fk_tag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 PACK_KEYS=0;

select 
_companies.id as _companies_id,
_companies.old_id as _companies_old_id,
_companies.official_name as _companies_official_name,
_companies.public_name as _companies_public_name 
... 
from companies as _companies 
where 
(_companies.status = '2' and _companies.id in 
(select fk_company from tag2comp where fk_tag in (48636))) 
order by _companies.priority asc limit 0,10

select distinct
_companies.id as _companies_id,
_companies.old_id as _companies_old_id,
_companies.official_name as _companies_official_name,
_companies.public_name as _companies_public_name 
... 
from companies as _companies 
inner join tag2comp as t2c on _companies.id=t2c.fk_company AND fk_tag IN (48636)
where (_companies.status = '2') order by _companies.priority asc limit 0,10

select 
_companies.id as _companies_id,
_companies.old_id as _companies_old_id,
_companies.official_name as _companies_official_name,
_companies.public_name as _companies_public_name 
... 
from companies as _companies 
where 
(_companies.status = '2' and _companies.id in 
(select fk_company from tag2comp where fk_tag in (8,47,559,564,565,566,569,570,571,6614,567,568,560,572,573,574,575,6692,6699,561,562,86,581,582,583,584,6749,6750,6751,563,585,586,6719,6722,6723,6724,6725,48,587,6579,6580,6581,588,589,6584,6585,6586,590,591,6693,592,6582,6583,6694,49,97,593,6611,6612,594,6609,6610,595,596,597,598,599,601,602,603,604,605,606,600,6587,6591,6592,6650,6665,6688,6720,6726))) 
order by _companies.priority asc limit 0,10

select distinct
_companies.id as _companies_id,
_companies.old_id as _companies_old_id,
_companies.official_name as _companies_official_name,
_companies.public_name as _companies_public_name 
... 
from companies as _companies 
inner join tag2comp as t2c on _companies.id=t2c.fk_company AND fk_tag IN (8,47,559,564,565,566,569,570,571,6614,567,568,560,572,573,574,575,6692,6699,561,562,86,581,582,583,584,6749,6750,6751,563,585,586,6719,6722,6723,6724,6725,48,587,6579,6580,6581,588,589,6584,6585,6586,590,591,6693,592,6582,6583,6694,49,97,593,6611,6612,594,6609,6610,595,596,597,598,599,601,602,603,604,605,606,600,6587,6591,6592,6650,6665,6688,6720,6726)
where (_companies.status = '2') order by _companies.priority asc limit 0,10