select banner,prodgroup_id from banner_ads
		where banner_id='5'

select aff_link_like from affiliate_config

select link from product_groups where prodgroup_id = ''

select type,sale_wait from product_groups
			       where prodgroup_id=''

delete from views where d < DATE_SUB(CURDATE(),INTERVAL 365 day)

select view_id from views where banner_id='5' and affiliate_id='1009' and prod_id='1' and d>='2024-04-28 00:00:00' and d<='2024-04-28 23:59:59'

insert into views (banner_id,banner_type,d,ip,referrer,affiliate_id,prod_id,views_count) values ('5','0',now(),'3.12.71.237','','1009',1,'1')

select count(*) from clicks where date_clicked>='2024-04-01 00:00:00' and date_clicked<='2024-04-28 23:59:59'

select count(*) from views where YEAR(d) = YEAR(CURDATE()) AND MONTH(d) = MONTH(CURDATE())