1021 -

SELECT mg.*, mbt.type, GROUP_CONCAT(gtc.categories_id) AS categories_id FROM mods_groups mg LEFT JOIN mods_block_types AS mbt on mg.block_type_id = mbt.id LEFT JOIN groups_to_categories AS gtc ON mg.id = gtc.groups_id WHERE mg.position_type IS NULL AND ((mg.group_key NOT like 'POPUP_%' AND mg.group_key NOT like 'BANNER_ABOVE_MENU%') OR mg.group_key IS NULL) AND mg.enabled = 1 AND mbt.type != 'product_listing_rentable' AND mg.exclusive_categories = 0 AND mg.exclusive_manufacturers = 0 AND mg.screen_type = 1 AND mg.enabled = 1 AND (IF(mbt.is_banner = 0, 1, (SELECT count(1) AS cantidad FROM banners b WHERE b.group_id = mg.id AND b.status= 1)) ) > 0 AND mg.preview = 0 GROUP BY mg.id ORDER BY mg.position

[TEP STOP]