source photos_main
{
  sql_range_step = 5000
  sql_query_post =
  sql_ranged_throttle = 0

      type = mysql
      sql_query_pre = SET SESSION group_concat_max_len = 65535
      sql_query_pre = SET NAMES utf8

sql_db = autofocus_virgin
sql_host = localhost
sql_pass =
sql_sock = /tmp/mysql.sock
sql_user = root
sql_query_range = SELECT MIN(id) , MAX(id) FROM photos
sql_query = SELECT (photos.id * 5 + 3) AS id, '' AS activities, '' AS best_bet, '' AS bio, '' AS body, photos.caption AS caption, '' AS category, 'Photo' AS class, 3 AS class_id, '' AS college, '' AS event_date_count, '' AS event_date_date, '' AS event_name, '' AS event_start_date, '' AS first_name, '' AS highschool, '' AS hometown, '' AS interests, '' AS last_name, '' AS login, '' AS name, '' AS occupation, '' AS sub_category, CAST(GROUP_CONCAT(DISTINCT autofocustags.name  SEPARATOR ' ') AS CHAR) AS tags, '' AS title, '' AS venue_cost, '' AS venue_description, '' AS venue_full, '' AS venue_location, '' AS venue_name, '' AS venue_online, '' AS venue_print FROM photos JOIN taggings ON taggings.taggable_id = photos.id AND taggings.taggable_type = "Photo" LEFT JOIN tags autofocus_tags ON autofocus_tags.id = taggings.tag_id AND autofocus_tags.name NOT LIKE "%:%=%" WHERE photos.id >= $start AND photos.id <= $end AND ((flag_count < 5) AND (site_id = 4)) GROUP BY photos.id

sql_attr_uint = class_id
sql_query_info = SELECT * FROM photos WHERE photos.id = (($id - 3) / 5)
}