23 -
SELECT mg.*, mbt.type, b.banners_title
FROM mods_groups mg
LEFT JOIN mods_block_types AS mbt on mg.block_type_id = mbt.id
INNER JOIN banners AS b on b.group_id = mg.id
WHERE mg.group_key like 'POPUP_SUBSCRIPTION'
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]
1016 -
select count(1) as total from sessions where sesskey = 'b19pmohlic23eqtoi1v1108370'
[TEP STOP]