Îøèáêà ÁÄ:
(SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108878 AND pv.`prop_id` = 1 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 3268 AND pv.`prop_id` = 1 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 109343 AND pv.`prop_id` = 1 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108095 AND pv.`prop_id` = 1 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108878 AND pv.`prop_id` = 2 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 3268 AND pv.`prop_id` = 2 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 109343 AND pv.`prop_id` = 2 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108095 AND pv.`prop_id` = 2 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108878 AND pv.`prop_id` = 100497 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 3268 AND pv.`prop_id` = 100497 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 109343 AND pv.`prop_id` = 100497 ORDER BY t_ids.link_id, t_all.cleft ASC) UNION ALL (SELECT t_ids.`link_id`, t_all.`link_id` as parent_id, pv.`prop_id`, pv.`value`, pv.`value_id` FROM tree t_ids JOIN tree t_all ON (t_ids.`cleft` BETWEEN t_all.`cleft` AND t_all.`cright`) JOIN prop_values pv ON (pv.parent_id = t_all.link_id) JOIN properties pr ON (pv.prop_id = pr.id) WHERE t_ids.`link_id` = 108095 AND pv.`prop_id` = 100497 ORDER BY t_ids.link_id, t_all.cleft ASC);
Out of resources when opening file './ridgid_db/tree.MYD' (Errcode: 24)