SELECT  I.not_date, I.id, I.content, I.title, R.RESOURCE_LOGO, R.RESOURCE_PAGE_URL, R.RESOURCE_NAME
FROM items I, section_items SI, resource R
WHERE SI.section_id =6
AND SI.user_id =3
AND I.id = SI.item_id
AND I.res_id = R.RESOURCE_ID
AND I.not_date <=  '2015-11-05'
ORDER BY I.not_date DESC, I.nd_date DESC
LIMIT 0 , 10

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`)
) ENGINE=Aria  DEFAULT CHARSET=utf8 PAGE_CHECKSUM=0 AUTO_INCREMENT=8020928 ;

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`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=608096 ;