postgres7 error: [-1: ERROR: column "main_type" does not exist LINE 5: WHERE main_type = 'Rugs' ^] in EXECUTE("SELECT count(distinct(i.instance_id)) FROM ct_index i INNER JOIN wf_view v ON i.instance_id = v.instance_id AND ((v.state_id=1 AND i.instance_type IN ('63:Section','65:Section','37:Section','44:SiteMap','57:Topic','55:ProductGroup','59:ProductPack','54:Product','56:Product','47:Link','58:CompositeSection','41:File','45:Form','62:Document','64:Document','60:Document','50:Document')) OR (v.state_id=2 AND i.instance_type IN ('58:CompositeSection','62:Document','64:Document','60:Document','50:Document','41:File','45:Form','47:Link','54:Product','56:Product','63:Section','65:Section','37:Section','44:SiteMap'))) WHERE main_type = 'Rugs'")

postgres7 error: [-1: ERROR: column "main_type" does not exist LINE 5: WHERE main_type = 'Rugs' ^] in EXECUTE("SELECT distinct ON (p.priority, i.instance_id) i.instance_id FROM ct_index i INNER JOIN wf_view v ON i.instance_id = v.instance_id AND ((v.state_id=1 AND i.instance_type IN ('63:Section','65:Section','37:Section','44:SiteMap','57:Topic','55:ProductGroup','59:ProductPack','54:Product','56:Product','47:Link','58:CompositeSection','41:File','45:Form','62:Document','64:Document','60:Document','50:Document')) OR (v.state_id=2 AND i.instance_type IN ('58:CompositeSection','62:Document','64:Document','60:Document','50:Document','41:File','45:Form','47:Link','54:Product','56:Product','63:Section','65:Section','37:Section','44:SiteMap'))) LEFT JOIN tc_priority p ON p.instance_id=i.instance_id AND topic_id=1625 WHERE main_type = 'Rugs' ORDER BY p.priority asc LIMIT 12 OFFSET 0 ;")