SELECT mg.*, mbt.type
FROM mods_groups mg
LEFT JOIN mods_block_types AS mbt on mg.block_type_id = mbt.id
WHERE mg.group_key like 'POPUP_INICIO'
AND mg.enabled = 1
AND mg.screen_type = 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
[TEP STOP]
-
select count(1) as total from sessions where sesskey = ''