unir tablas despues ordenar y contar

[quimfv]

Código MySQL:

SELECT sbc.value,count(*)
FROM
(SELECT `content_field_l1_lista`.`field_l1_lista_value` as value
FROM content_field_l1_lista
UNION ALL 
SELECT `content_field_l2_lista`.`field_l2_lista_value` as value
FROM content_field_l2_lista
UNION ALL 
SELECT `content_field_l3_lista`.`field_l3_lista_value` as value
FROM content_field_l3_lista) as sbc
GROUP BY sbc.value
ORDER BY  COUNT( * ) DESC;
 

Creo...