Notice: Only variable references should be returned by reference in /home/default/vhosts/maritimeindustryfoundation.com/httpdocs/includes/db/adodb/adodb-connection.inc.php on line 391
Unknown column 'ic.class_tag' in 'on clause'
in datasource id..2441..tag..get_members_pr_from_cms..
on SQL Command :
SELECT ic.instance_tag, date_format( a1.value, "%d %b %y" ) AS formatted_start_date, a1.value AS start_date, a2.value AS pr_heading, a3.value AS pr_file, a4.value AS pr_source, a7.value AS pr_description FROM cm_instance_copy ic, cm_instance_attribute a INNER JOIN cm_instance i ON i.class_tag = ic.class_tag AND i.instance_id = ic.instance_id INNER JOIN cm_instance_attribute a1 ON a1.class_tag = ic.class_tag AND a1.instance_id = ic.instance_id AND a1.attribute_tag = "start_date" AND a1.copy = ic.copy AND a1.value < now() INNER JOIN cm_instance_attribute a2 ON a2.class_tag = ic.class_tag AND a2.instance_id = ic.instance_id AND a2.attribute_tag = "pr_heading" AND a2.copy = ic.copy INNER JOIN cm_instance_attribute a3 ON a3.class_tag = ic.class_tag AND a3.instance_id = ic.instance_id AND a3.attribute_tag = "pr_file" AND a3.copy = ic.copy INNER JOIN cm_instance_attribute a4 ON a4.class_tag = ic.class_tag AND a4.instance_id = ic.instance_id AND a4.attribute_tag = "pr_source" AND a4.copy = ic.copy INNER JOIN cm_instance_attribute a5 ON a5.class_tag = ic.class_tag AND a5.instance_id = ic.instance_id AND a5.attribute_tag = "pr_expiry_dt" AND a5.copy = ic.copy AND a5.value > now() INNER JOIN cm_instance_attribute a6 ON a6.class_tag = ic.class_tag AND a6.instance_id = ic.instance_id AND a6.attribute_tag = "member_id" AND a6.copy = ic.copy AND a6.value = "DNV" INNER JOIN cm_instance_attribute a7 ON a7.class_tag = ic.class_tag AND a7.instance_id = ic.instance_id AND a7.attribute_tag = "description" AND a7.copy = ic.copy WHERE i.deleted_flag =0 AND a.class_tag = ic.class_tag AND a.instance_id = ic.instance_id AND a.attribute_tag = 'active' AND a.copy = ic.copy AND a.value = "YES" AND ic.class_tag LIKE 'press_release' AND ic.copy = "PUBLISHED" ORDER BY start_date DESC