Error in query - 1030 - Got error 28 from storage engine SQL:
select
p.id id,
t1.value_ja_data name,
'ja_data' lang_code,
t2.value_ja_data description,
p.institution_id institution_id,
p.sort sort
from tks_collections p
left join tks_coll_keywords pp
on pp.collection_id = p.id
left outer join object_textvalues_col t1 on
t1.text_id = p.name_txtid
left outer join object_textvalues_col t2 on
t2.text_id = p.description_txtid
where keyword_id='1059'
order by name
|