# Source for topics
source topicsSource : lsParentSource
{
        sql_query               = \
                SELECT t_fast.topic_id, t_fast.topic_title, UNIX_TIMESTAMP(t_fast.topic_date_add) as topic_date_add, \
                tc.topic_text, t_fast.topic_publish \
                FROM ls_topic as t_fast, ls_topic_content AS tc \
                WHERE t_fast.topic_id=tc.topic_id \
		AND t_fast.blog_id \
			IN ( \
				SELECT blog_id FROM ls_blog \
				WHERE blog_type = 'open' \
			) \
		AND t_fast.topic_id>=$start \
		AND t_fast.topic_id<=$end

        sql_query_range         = SELECT MIN(topic_id),MAX(topic_id) FROM ls_topic
        sql_range_step          = 10000
        sql_attr_bool           = topic_publish
        sql_attr_timestamp      = topic_date_add
        sql_attr_multi  = uint tag from query; SELECT topic_id, topic_tag_id FROM ls_topic_tag
        sql_ranged_throttle     = 0
}
# Source for comments
source commentsSource : lsParentSource
{
        sql_query               = \
		SELECT comment_id, comment_text, UNIX_TIMESTAMP( comment_date ) AS comment_date, comment_delete \
		FROM ls_comment \
		WHERE target_type =  'topic' \
		AND target_parent_id \
		IN ( \
			SELECT blog_id \
			FROM ls_blog \
			WHERE blog_type =  'open' \
		) \
		AND comment_id>=$start \
		AND comment_id<=$end

        sql_query_range         = SELECT MIN(comment_id),MAX(comment_id) FROM ls_comment
        sql_range_step          = 10000
        sql_attr_bool           = comment_delete
        sql_attr_timestamp      = comment_date
}