An outdoors social network for the traveling & outdoors enthusiast - MyOutdoorAdventure.com

Cannot Perform Query: Unknown column 'p.group_primary' in 'on clause'

QUERY:
SELECT g.title, g.seo_title FROM groups g LEFT JOIN group_photos p ON (p.group_id = g.group_id AND p.group_primary = 1) WHERE g.member_id = 6 UNION SELECT g.title, g.seo_title FROM groups g LEFT JOIN group_photos p ON (p.group_id = g.group_id AND p.group_primary = 1) JOIN group_members mg ON g.group_id = mg.group_id WHERE mg.member_id=6