SELECT cat_group_id AS id, parent, name, short, meta_title, meta_description, meta_keywords, picture, picture_yellow
            FROM webshop_categories AS wc
            WHERE
                deleted = '0'
                AND sections_id LIKE '%1%'
                AND lng = 'hu'
                AND parent = '74'
                AND parent != '73'
                AND cat_group_id != '73'
                AND (parent = 0
                    OR (SELECT COUNT(prod_id)
                        FROM webshop_products AS wp
                        WHERE
                            wc.cat_group_id = wp.cat_id
                            AND wp.sections_id LIKE '%1%'
                            AND wp.lng = 'hu'
                            AND wp.deleted = '0'
                        LIMIT 1
                    ) > 0
                )
            ORDER BY parent ASC, priority ASC<br />2013: Lost connection to server during query