Contar Total Tablas Dentro De Un Join.

[seyko]

añade al from:

(
select count(articulos.id) as total_reg
FROM
intranet_app.articulos,
intranet_app.articulos_sel,
intranet_app.clientes,
intranet_app.tecnicos

WHERE articulos.cliente_id = clientes.id
AND articulos.articulo_id = articulos_sel.id
AND tecnicos.id = articulos.tecnico_id
GROUP BY articulos.id
LIMIT 0 , 30;
) total

y en el select:
select total.total_reg

Salu2