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 = 45
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=45
Halofan
