SELECT C.country_name, COUNT( I.id ) AS count
FROM section_items S, countries C, resource R, items I
WHERE S.section_id =6
AND I.id = S.item_id
AND R.resource_id = I.res_id
AND C.id = R.COUNTRY_ID
AND I.not_date <=  '2015-11-11'
GROUP BY C.country_name
ORDER BY count DESC

CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `log_id` int(11) NOT NULL,
  `res_id` int(11) NOT NULL,
  `link` varchar(255) NOT NULL,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `n_date` varchar(255) NOT NULL,
  `nd_date` int(11) NOT NULL,
  `s_date` int(11) NOT NULL,
  `not_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `link_2` (`link`),
  KEY `log_id` (`log_id`),
  KEY `res_id` (`res_id`),
  KEY `now_date` (`not_date`),
  KEY `sql_index` (`res_id`,`id`,`not_date`)
) ENGINE=Aria  DEFAULT CHARSET=utf8 PAGE_CHECKSUM=0 AUTO_INCREMENT=9129638 ;

CREATE TABLE IF NOT EXISTS `section_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ix_phone` (`section_id`,`item_id`,`user_id`),
  KEY `user_id` (`user_id`),
  KEY `section_id` (`section_id`),
  KEY `item_index` (`item_id`),
  KEY `sql_index` (`user_id`,`section_id`,`item_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=630874 ;