See also this artistic contribution to…
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 '?media=174
AND c.liststatus='Active'
)
' at line 6(SELECT a.id as mediaid, c.artist as artistid, c.id as contributionid, c.title as medialabel, a.description, a.media as mediafile, a.mediaFormat1, concat(c.firstname,' ',c.grouplastname) as mediaartist, a.preview
FROM enmedia a, contribution c, match_contribution_enmedia m
WHERE c.encounter = 7
AND a.id=m.sub_id AND c.id=m.main_id
AND c.id!=91
AND a.id!=174?media=174
AND c.liststatus='Active'
)
UNION
(
SELECT a.id as mediaid, c.artist as artistid, c.id as contributionid, c.title as medialabel, a.description, a.media as mediafile, a.mediaFormat1, concat(c.firstname,' ',c.grouplastname) as mediaartist, a.preview
FROM userenmedia a, usercontribution c, match_usercontribution_userenmedia m
WHERE c.encounter = 7
AND a.id=m.sub_id AND c.id=m.main_id
AND c.id!=91
AND a.id!=174?media=174
AND c.liststatus='Active'
)
ORDER BY RAND()
LIMIT 3