SELECT banner_id FROM ?:banners  LEFT JOIN ?:banner_descriptions ON ?:banner_descriptions.banner_id = ?:banners.banner_id AND ?:banner_descriptions.lang_code = 'en' LEFT JOIN ?:banner_images ON ?:banner_images.banner_id = ?:banners.banner_id AND ?:banner_images.lang_code = 'en' INNER JOIN ?:banner_categories ON ?:banner_categories.banner_id = ?:banners.banner_id AND ?:banner_categories.position = 'T'WHERE 1 cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.required_products, cscart_banners.index_top, cscart_banners.index_bottom, cscart_banners.category_top, cscart_banners.category_bottom, cscart_banners.product_top, cscart_banners.product_bottom, cscart_banners.display_from, cscart_banners.display_to, cscart_banners.required_products, cscart_banners.show_on_category, cscart_banners.show_on_category_bottom  AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.product_top = 'Y' AND cscart_banners.status = 'A' AND cscart_banner_categories.category_id = 295 AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N'
OR
(
cscart_banners.abt__ut2_use_avail_period = 'Y'
AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1752485787)
AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1752485787)
)
), 'available', 'not available') ) = 'available'  AND cscart_banners.destinations = 0 AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids))  ORDER BY RAND()

SELECT banner_id FROM ?:banners  LEFT JOIN ?:banner_descriptions ON ?:banner_descriptions.banner_id = ?:banners.banner_id AND ?:banner_descriptions.lang_code = 'en' LEFT JOIN ?:banner_images ON ?:banner_images.banner_id = ?:banners.banner_id AND ?:banner_images.lang_code = 'en' INNER JOIN ?:banner_categories ON ?:banner_categories.banner_id = ?:banners.banner_id AND ?:banner_categories.position = 'B'WHERE 1 cscart_banners.banner_id, cscart_banners.type, cscart_banners.target, cscart_banners.status, cscart_banners.timestamp, cscart_banner_descriptions.banner, cscart_banner_descriptions.description, cscart_banner_descriptions.url, cscart_banner_images.banner_image_id, cscart_banners.required_products, cscart_banners.index_top, cscart_banners.index_bottom, cscart_banners.category_top, cscart_banners.category_bottom, cscart_banners.product_top, cscart_banners.product_bottom, cscart_banners.display_from, cscart_banners.display_to, cscart_banners.required_products, cscart_banners.show_on_category, cscart_banners.show_on_category_bottom  AND (cscart_banners.type != 'G' OR cscart_banner_images.banner_image_id IS NOT NULL) AND cscart_banners.product_bottom = 'Y' AND cscart_banners.status = 'A' AND cscart_banner_categories.category_id = 295 AND IF (cscart_banners.type not like 'abt__ut2', 'available', IF ( cscart_banners.type like 'abt__ut2' AND ( cscart_banners.abt__ut2_use_avail_period = 'N'
OR
(
cscart_banners.abt__ut2_use_avail_period = 'Y'
AND (cscart_banners.abt__ut2_avail_from = 0 OR cscart_banners.abt__ut2_avail_from <= 1752485787)
AND (cscart_banners.abt__ut2_avail_till = 0 OR cscart_banners.abt__ut2_avail_till >= 1752485787)
)
), 'available', 'not available') ) = 'available'  AND cscart_banners.destinations = 0 AND (cscart_banners.abt__ut2_usergroup_ids = '' OR FIND_IN_SET(0, cscart_banners.abt__ut2_usergroup_ids) OR FIND_IN_SET(1, cscart_banners.abt__ut2_usergroup_ids))  ORDER BY cscart_banners.timestamp desc