SELECT prodgroup.*,prodgroup_lang.name as cim,prodgroup_lang.content as content from prodgroup
join prodgroup_lang on(prodgroup_lang.group_id=prodgroup.id)
Where prodgroup.id=id AND prodgroup.valid=1 AND prodgroup_lang.language=4 Column 'id' in where clause is ambiguous