Чтобы выполнить множественный подсчет в MySQL, вы можете использовать различные подходы. Вот несколько методов с примерами кода:

Метод 1: использование подзапросов

SELECT
    (SELECT COUNT(*) FROM table1) AS count1,
    (SELECT COUNT(*) FROM table2) AS count2,
    (SELECT COUNT(*) FROM table3) AS count3;

Метод 2: использование UNION ALL

SELECT 'table1' AS tablename, COUNT(*) AS count FROM table1
UNION ALL
SELECT 'table2' AS tablename, COUNT(*) AS count FROM table2
UNION ALL
SELECT 'table3' AS tablename, COUNT(*) AS count FROM table3;

Метод 3: использование операторов CASE

SELECT
    COUNT(*) AS total,
    SUM(CASE WHEN condition1 THEN 1 ELSE 0 END) AS count1,
    SUM(CASE WHEN condition2 THEN 1 ELSE 0 END) AS count2,
    SUM(CASE WHEN condition3 THEN 1 ELSE 0 END) AS count3
FROM
    your_table;

Метод 4: использование GROUP BY

SELECT
    COUNT(*) AS total,
    SUM(column1 = 'value1') AS count1,
    SUM(column2 = 'value2') AS count2,
    SUM(column3 = 'value3') AS count3
FROM
    your_table;