Skip to content

Instantly share code, notes, and snippets.

@illogicalextend
Created June 12, 2013 04:22
Show Gist options
  • Save illogicalextend/5762818 to your computer and use it in GitHub Desktop.
Save illogicalextend/5762818 to your computer and use it in GitHub Desktop.
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_cred
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment