SELECT pd.pi_collection_id, p1.pi_group_id, p1.pi_group_name, p1.pi_group_alias, p1.short_name, p1.pi_group_description, p1.summary_prompt, p2.pi_group_name as pi_group_name2, p2.pi_group_alias as pi_group_alias2, p2.pi_group_description as pi_group_description2, p2.summary_prompt as summary_prompt2, p1.status, p1.report_status, p1.show_option, p1.show_name, p1.layout, p1.repeating, p1.default_rows, p1.columns, p1.location_inline, p1.location_disable, p1.hide FROM picollectiondata pd LEFT JOIN pivirtualcollections pv ON (pd.pi_collection_id=pv.pi_collection_id), pigroups p1 LEFT JOIN pigroupslocal p2 ON (p1.pi_group_id=p2.pi_group_id AND p2.loc_id='en_CA') WHERE p1.pi_group_id=pd.pi_group_id AND pv.vt_collection_id=1169 ORDER BY pv.sequence, pd.sequence
Got error 28 from storage engine