SELECT * FROM Resources AS Models
LEFT JOIN Resources AS Designs ON (Designs.parent_id = Models.id AND Designs.template_id = id шаблона дизайна модели)
LEFT JOIN Resources AS Batches ON (Batches.parent_id = Designs.id AND Batches.template_id = id шаблона серии дизайна)
WHERE Models.parent_id IS NULL
AND Designs.id IS NOT NULL
AND Batches.id IS NOT NULL
SELECT `name`, REGEXP_REPLACE(`name`, '([a-zа-яё])([A-ZА-ЯЁ])', '\\1 \\2', 1, 0, 'c') FROM `prefix_users` WHERE REGEXP_LIKE(`name`, '([a-zа-яё])([A-ZА-ЯЁ])', 'c')
UPDATE `prefix_users` SET `name`=REGEXP_REPLACE(`name`, '([a-zа-яё])([A-ZА-ЯЁ])', '\\1 \\2', 1, 0, 'c') WHERE REGEXP_LIKE(`name`, '([a-zа-яё])([A-ZА-ЯЁ])', 'c')