Level 102
Just do two queries https://laravel.com/docs/9.x/eloquent#retrieving-aggregates
1 like
Apr 14, 2022
10
Level 2
How to query multiple tables in one go?
Hi. I want to get total number of users (for past month) and total_number of posts (for 2 months ago). How can I use one Mysql query to grap above information?
Level 2
@Sinnbeck You mean its not possible to do that with one query?
Level 102
@danimohamadnejad it might be possible, but it would be harder to understand/debug. And even if it was faster, it wouldnt be by alot (it might even be slower)
1 like
Level 2
@Sinnbeck Thank you
Level 39
You could do everything with sql but why do you want to have only one if 2 are simpler?
Level 2
Thank you all. Following is almost what I need:
select (select count(*) from users) as users_count, (select count(*) from posts) as posts_count;
Level 39
Level 102
@danimohamadnejad that query isn't limited to 2 months. I also assumed you wanted to write it in laravel, not directly in mysql? And be sure to test if it is actually faster than just doing 2 queries, and that the results are the same
1 like
Level 2
@Sinnbeck Thank you I will check speed. Criteria must be applied to both sub queries and I am using Laravel DB facade to do that
Level 102
@danimohamadnejad show what you have in laravel at least :)
Please or to participate in this conversation.