gistfile1.sql

select  `article`.`id`,`article`.`image_id`,(select  concat('/', `_f`.`dirname`, '/', `filestore_file`.`filename`) `url` from `filestore_file` left join `filestore_volume` as `_f` on `_f`.`id` = `filestore_file`.`filestore_volume_id` inner join `filestore_image` as `_f_3` on `_f_3`.`original_file_id` = `filestore_file`.`id` where `article`.`image_id` = `filestore_file`.`id`    ) `image`,(select  concat('/', `_f`.`dirname`, '/', `filestore_file`.`filename`) `url` from `filestore_file` left join `filestore_volume` as `_f` on `_f`.`id` = `filestore_file`.`filestore_volume_id` inner join `filestore_image` as `_f_3` on `_f_3`.`original_file_id` = `filestore_file`.`id` where `article`.`image_id` = `filestore_file`.`id`    ) `image_4`,`article`.`show_photo_in_article`,`article`.`title`,`article`.`description`,`article`.`text`,`article`.`url_hash`,`article`.`date`,`article`.`time`,`article`.`meta_keywords`,`article`.`meta_description`,`article`.`news_of_the_day`,`article`.`is_published`,`article`.`is_archived`,`article`.`is_blocked`,`article`.`main_news`,`article`.`from_name`,`article`.`from_url`,`article`.`is_migrated`,`article`.`migrated_image`,`article`.`migrated_image_json`,`article`.`photo_author`,`article`.`user_id`,(select  `user`.`name` from `user`  where `user`.`type` in ('admin','author') and `article`.`user_id` = `user`.`id`    ) `user`,`article`.`category`,concat(date," " , time) `date_time`,`article`.`title` `name`,`article`.`views`,(select  (select  concat('/', `_f`.`dirname`, '/', `filestore_file`.`filename`) `url` from `filestore_file` left join `filestore_volume` as `_f` on `_f`.`id` = `filestore_file`.`filestore_volume_id` where `filestore_file`.`id` = `_f_5`.`thumb_file_id`    ) `thumb_url` from `filestore_file` left join `filestore_volume` as `_f_4` on `_f_4`.`id` = `filestore_file`.`filestore_volume_id` inner join `filestore_image` as `_f_5` on `_f_5`.`original_file_id` = `filestore_file`.`id` where `filestore_file`.`id` = `article`.`image_id`    ) `image_thumb`,`_a`.`category_id`,`_a`.`article_id` `_a` from `article` inner join `article_category` as `_a` on `_a`.`article_id` = `article`.`id` where `article`.`is_published` = 1 and `article`.`is_archived` = 0 and `article`.`is_blocked` = 0 and concat(date," " , time) < '2014-04-09 18:11:22' and `_a`.`category_id` = '18'   order by concat(date," " , time) desc limit 0,