Merge loop of SQL queries into one SQL query
Use conditional aggregation:
SELECT COUNT(CASE WHEN u0_.email LIKE '%@company1.com' THEN 1 END) as First_cnt, COUNT(CASE WHEN u0_.email LIKE '%@company2.com' THEN 1 END) as First_cntFROM user u0_
Use conditional aggregation:
SELECT COUNT(CASE WHEN u0_.email LIKE '%@company1.com' THEN 1 END) as First_cnt, COUNT(CASE WHEN u0_.email LIKE '%@company2.com' THEN 1 END) as First_cntFROM user u0_