SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND contents.status="published" AND contents.lang='en' ORDER BY rand()' at line 1

SQL: SELECT nodes.nid,contents.cid,contents.name,contents.url,contents.link,m.media_name FROM contents JOIN nodes ON(nodes.nid = contents.nid) JOIN medias m ON (nodes.nid = m.nid AND m.media_type = "ad_pic" AND (m.media_lang=contents.lang OR m.media_lang IS NULL)) JOIN m2m ON (m2m.nid1 = nodes.nid AND m2m.nid2=shopping AND m2m.node1_lang = contents.lang) WHERE ftype="ad_col" AND contents.flag != 1 AND (contents.start_date < now() OR contents.start_date IS NULL) AND (contents.end_date > now() OR contents.end_date IS NULL) AND (contents.uid > 0 OR contents.uid IS NULL) AND m2m.val= AND contents.status="published" AND contents.lang='en' ORDER BY rand()

Array ( [0] => 00000 ) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND contents.status="published" AND contents.lang='en' ORDER BY rand()' at line 1

SQL: SELECT nodes.nid,contents.cid,contents.name,contents.url,contents.link,m.media_name FROM contents JOIN nodes ON(nodes.nid = contents.nid) JOIN medias m ON (nodes.nid = m.nid AND m.media_type = "ad_square_pic" AND (m.media_lang=contents.lang OR m.media_lang IS NULL)) JOIN m2m ON (m2m.nid1 = nodes.nid AND m2m.nid2=shopping AND m2m.node1_lang = contents.lang) WHERE ftype="ad_square" AND (contents.start_date < now() OR contents.start_date IS NULL) AND (contents.end_date > now() OR contents.end_date IS NULL) AND (contents.uid > 0 OR contents.uid IS NULL) AND m2m.val= AND contents.status="published" AND contents.lang='en' ORDER BY rand()

Array ( [0] => 00000 ) SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND contents.status="published" AND contents.lang='en' ORDER BY rand() ' at line 1

SQL: SELECT nodes.nid,contents.cid,contents.name,contents.url,contents.link,m.media_name FROM contents JOIN nodes ON(nodes.nid = contents.nid) JOIN medias m ON (nodes.nid = m.nid AND m.media_type = "ad_tile_pic" AND (m.media_lang=contents.lang OR m.media_lang IS NULL)) JOIN m2m ON (m2m.nid1 = nodes.nid AND m2m.nid2=shopping AND m2m.node1_lang = contents.lang) WHERE ftype="ad_tile" AND (contents.start_date < now() OR contents.start_date IS NULL) AND (contents.end_date > now() OR contents.end_date IS NULL) AND (contents.uid > 0 OR contents.uid IS NULL) AND m2m.val= AND contents.status="published" AND contents.lang='en' ORDER BY rand() LIMIT 0,4

Array ( [0] => 00000 )