Sign up for a GitHub account Sign in Discover Gists public qpfiffer / hahaha.sql Created 2014-05-01 Gist Detail Revisions 1 Download Gist Clone this gist Embed this gist Link to this gist hahaha.sql SQL File suppressed. Click to show. 1 2 3 4 select * from django_snailtracker_action as ac join django_snailtracker_snailtrack as st on st . id = ac . snailtrack_id join django_content_type as ct on st . content_type_id = ct . id where ct . name = 'supplier' and 'invoiced' = any (( select ( '[' || value :: text || ']' ):: json ->> 0 from json_array_elements ( columns_changed :: json ))); Please sign in to comment on this gist. Something went wrong with that request. Please try again. Served fresh by github-fe102-cp1-prd.iad.github.net © 2014...