gistfile1.sql

SELECT `Post`.`id`, `Post`.`service_id`, `Post`.`campaign_id`, `Post`.`from_name`, `Post`.`from_id`, `Post`.`from_img`, `Post`.`message`, `Post`.`picture`, `Post`.`link`, `Post`.`name`, `Post`.`name_href`, `Post`.`name_caption`, `Post`.`description`, `Post`.`comment_count`, `Post`.`updated_timestamp`, `Post`.`service`, `Post`.`in_reply_to_status_id`, `Post`.`created_time`, `Post`.`user_actions`, `Post`.`is_read`, `Post`.`is_read_user`, `Post`.`from_cms`, `Post`.`from_user`, `Post`.`categories`, `Post`.`tags`, `Post`.`type`, `Post`.`post_type_id`, `Post`.`competitor`, `Post`.`attribution_text`, `Post`.`attribution_url`, `Post`.`attribution_logo`, `Post`.`data`, `Post`.`assignment_id`, `Post`.`connection_id`, `Post`.`status`, `Post`.`is_flagged`, `Post`.`user_id`, `User`.`display_name`, `Campaign`.`id`, `Campaign`.`title`, `Campaign`.`www`, `Campaign`.`archived`, `Campaign`.`autopost`, `Campaign`.`autopost_error`, `Campaign`.`monitor`, `Campaign`.`holiday_posts`, `Campaign`.`sweepstake_posts`, `Campaign`.`notes`, `Campaign`.`posts_per_month`, `Campaign`.`listing_date`, `Campaign`.`content_type`, `Campaign`.`posting_notes`, `Campaign`.`monitoring_notes`, `Campaign`.`emails`, `Campaign`.`contact_names`, `Campaign`.`craigslist_enable`, `Campaign`.`craigslist_email`, `Campaign`.`craigslist_password`, `Campaign`.`listing_id`, `Campaign`.`unique_client_market`, `Campaign`.`no_auto_content`, `Campaign`.`client_id`, `Campaign`.`city`, `Campaign`.`state`, `Campaign`.`propertyweb_enable`, `Campaign`.`seo_enable`, `Campaign`.`ppc_enable`, `Connection`.`id`, `Connection`.`campaign_id`, `Connection`.`service_id`, `Connection`.`name`, `Connection`.`url`, `Connection`.`email`, `Connection`.`competitor`, `Connection`.`last_update`, `Connection`.`title`, `Connection`.`lat`, `Connection`.`lng`, `Connection`.`token`, `Connection`.`token_secret`, `Connection`.`first_name`, `Connection`.`last_name`, `Connection`.`rating`, `Connection`.`rating_img`, `Connection`.`is_page`, `Connection`.`parent_id`, `Connection`.`type`, `Connection`.`feed_type`, `Connection`.`last_hub_post`, `Connection`.`picture_url`, `Connection`.`private_profile_url`, `Connection`.`public_profile_url`, `Connection`.`reference`, `Connection`.`wp_username`, `Connection`.`wp_password`, `Connection`.`wp_restaurants`, `Connection`.`wp_thingstodo`, `Connection`.`wp_other`, `Connection`.`disable_mapping`, `Connection`.`is_claimed`, `Connection`.`review_count`, `Connection`.`error`, `Connection`.`error_message`, `Connection`.`error_notes`, `Connection`.`error_timestamp`, `Connection`.`synch_timestamp`, `Connection`.`expires`, `Connection`.`old_connection_id`, `Connection`.`error_count`, `Connection`.`address`, `Connection`.`city`, `Connection`.`state`, `Connection`.`zip`, `PostType`.`id`, `PostType`.`name`, `PostType`.`description`, `Assignment`.`id`, `Assignment`.`campaign_id`, `Assignment`.`article_id`, `Assignment`.`recurring_post_id`, `Assignment`.`client_request_id`, `Assignment`.`run_id`, `Assignment`.`post_datetime`, `Assignment`.`editable`, `Assignment`.`article_title`, `Assignment`.`article_tags`, `Assignment`.`article_content`, `Assignment`.`category`, `Assignment`.`status`, `Assignment`.`status_info`, `Assignment`.`instructions`, `Assignment`.`type`, `Assignment`.`hidden`, `Assignment`.`user_id`, `Assignment`.`approved`, `Assignment`.`standard`, `Assignment`.`post_as_status`, `Assignment`.`no_thumbnail`, `Assignment`.`url`, `Assignment`.`error`, `Assignment`.`error_message`, `Assignment`.`error_notes`, `Assignment`.`error_timestamp`, `Assignment`.`user_post`, `Assignment`.`content_request_id` FROM `posts` AS `Post` LEFT JOIN `users` AS `User` ON (`Post`.`user_id` = `User`.`id`) LEFT JOIN `campaigns` AS `Campaign` ON (`Post`.`campaign_id` = `Campaign`.`id`) LEFT JOIN `connections` AS `Connection` ON (`Post`.`connection_id` = `Connection`.`id`) LEFT JOIN `post_types` AS `PostType` ON (`Post`.`post_type_id` = `PostType`.`id`) LEFT JOIN `assignments` AS `Assignment` ON (`Post`.`assignment_id` = `Assignment`.`id`) WHERE NOT (`Post`.`type` = 'talkwalker') AND `Campaign`.`monitor` = 1 AND `Post`.`updated_timestamp` >= 1392217500 AND ((`Post`.`from_user` = 0) OR (`Post`.`comment_count` > 0)) AND `Post`.`competitor` = 0 ORDER BY `updated_timestamp` desc LIMIT 25