GROUP BY rewrite to subqueries with easily interchangeable AND OR conditions Tables:

content        tag_map       extrainfo
|id|title|    |id|tagid|    |id|lat|lng|
|--|-----|    |--|-----|    |--|---|---|
|1 |Lorem|    |1 |8    |    |3 |0,4|0,1|
|2 |Ipsum|    |2 |9    |    |2 |1,1|1,2|
|3 |Dolor|    |1 |9    |
              |1 |7    |   


id is unique index

SELECT * FROM content, tag_map, extrainfo
WHERE
tag_map.id = content.id
AND
extrainfo.id = content.id

#AND OR conditions here
#conditions can be very different but I would like
#to use the same query structure
#just change conditions here as necessary

GROUP BY content.id


this query works - but slow.
I found the most alternatives involve subqueries, but I can`t figure out a way to use subqueries and still be able to freely change AND OR conditions that involve columns from ALL tables. 

Other non-subquery methods are welcome too.
First clean the join syntax:

SELECT * FROM content as c
inner join tag_map as t on c.id=t.id 
inner join extrainfo as e on c.id=e.id
WHERE
#AND OR conditions here
#conditions can be very different but I would like
#to use the same query structure
#just change conditions here as necessary
GROUP BY c.id


Now substitute your and/or clauses in place of the rem'd out lines above. Then look into indexing those columns (indexes should cover all the fields in the conditions). 

These simple steps will speed up significantly. If you need further speed ups, please post before and after speedup results along with complete details of existing indexes.