|
|||||||||||||||
|
Error in query - 1030 - Got error 28 from storage engine SQL: select distinct institution_id id, t1.value_ja name, 'ja' lang_code, t1.value_yo yname, left(t1.value_de,1) lname, left(t1.value_yo,1) lyname, count(pp.institution_id) count from tks_institutions p left join tks_collections pp on pp.institution_id = p.id left outer join object_textvalues_col t1 on t1.text_id = p.name_txtid where pp.id is not null group by institution_id order by yname |