selectcount(*) as aggregate from `conferences` wheredate(`date_show`) <='2025-03-26'and ((date(`date_create`) >='2026-01-01'anddate(`date_create`) <='2026-12-31') or (date(`date_end`) >='2026-01-01'anddate(`date_end`) <='2026-12-31') or (date(`date_create`) <='2026-01-01'anddate(`date_end`) >='2026-12-31'))
select `members`.*, `same_authorsables`.`same_authors_id` as `pivot_same_authors_id`, `same_authorsables`.`members_id` as `pivot_members_id`, `same_authorsables`.`same_authors_type` as `pivot_same_authors_type` from `members` innerjoin `same_authorsables` on `members`.`id` = `same_authorsables`.`members_id` where `same_authorsables`.`same_authors_id` in (1134, 1135, 1137) and `same_authorsables`.`same_authors_type` ='App\Models\Prints'