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

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=''

insert into views (banner_id,banner_type,d,ip,referrer,affiliate_id,prod_id)
	      values ('2','0',now(),'95.216.99.153','http://www.leslieannewroteit.com/','1318',1)

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

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