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