SELECT * FROM `data` WHERE
(`name` LIKE '%Поиск...%' OR short_description LIKE '%Поиск...%' OR full_description LIKE '%Поиск...%')
AND (data.id IN (
    SELECT data_id FROM data_category
    WHERE maincat_id IN (
        SELECT id FROM categories WHERE active=1
         )
        )
)