illogicalextend

        <cache>
          <backend>Cm_Cache_Backend_Redis</backend>
          <backend_options>
                  <server>127.0.0.1/server>
                  <port>6379</port>
                  <database>0</database>
                  <force_standalone>0</force_standalone>
                  <automatic_cleaning_factor>0</automatic_cleaning_factor>
                  <compress_data>1</compress_data>
                  <compress_tags>1</compress_tags>

illogicalextend

SELECT DISTINCT (completion_rating + additional_rating) AS "ranking"
        "users_gradaccount"."id"
        "users_gradaccount"."gc_account_id"
        "users_gradaccount"."name_slug"
        "users_gradaccount"."password_plaintext"
        "users_gradaccount"."completion_rating"
        "users_gradaccount"."additional_rating"
        "users_gradaccount"."old_id"
        "users_gradaccount"."location_id"
        "users_gradaccount"."birth_date"

illogicalextend

SELECT COUNT(*) FROM (SELECT DISTINCT "users_institution"."client_ptr_id" AS "client_ptr_id", "gradmaker_client"."slug" AS "slug", "gradmaker_client"."name" AS "name", "gradmaker_client"."display_name" AS "display_name"
, "gradmaker_client"."blurb" AS "blurb", "gradmaker_client"."heading_colour" AS "heading_colour", "gradmaker_client"."link_colour" AS "link_colour", "gradmaker_client"."banner" AS "banner", "gradmaker_client"."width" AS "width", "gradmak
er_client"."height" AS "height", "gradmaker_client"."about_content" AS "about_content", "gradmaker_client"."twitter_handle" AS "twitter_handle", "gradmaker_client"."facebook_fan_page_url" AS "facebook_fan_page_url", "gradmaker_client"."f
acebook_widget_size" AS "facebook_widget_size", "gradmaker_client"."twitter_widget_size" AS "twitter_widget_size", "gradmaker_client"."created" AS "created", "gradmaker_client"."last_modified" AS "last_modified", "gradmaker_client"."arti
cles_post_credits" AS "articles_post_credits", "gradmaker_client"."articles_announcement_c