select *, profiles.name as profile_name from profile_events
inner join profiles on profile_events.profileID=profiles.profileID
inner join profile_media on profile_media.mediaID = profiles.new_profile_pic
inner join companies on profiles.clientID=companies.clientID
inner join client_ad_contracts on companies.clientID=client_ad_contracts.clientID
inner join profile_categories on profiles.profileID=profile_categories.profileID
inner join categories on categories.categoryID=profile_categories.categoryID
where profiles.active = '1' and (companies.regionID = '1' or client_ad_contracts.second_city = '1') and
profile_events.display_start_date <= '2023-03-28' and profile_events.display_end_date >= '2023-03-28' and profiles.clientID <> '0' and profile_events.pending = '0'
and client_ad_contracts.start_date <= '2023-03-28' and date_add(date_add(client_ad_contracts.start_date, INTERVAL client_ad_contracts.contract_term MONTH), INTERVAL client_ad_contracts.extend MONTH) >= '2023-03-28'
group by profiles.profileID order by event_date asc, rand() limit 4
.png&x=1500&f=0&q=80&t=2)
