LINUX.ORG.RU

История изменений

Исправление exception13, (текущая версия) :

prefixes (id, prefix, description);
calls (..., direction, timestamp, destination,...);

SELECT data.direction, data.prefix_id, count(*) FROM (SELECT *, (SELECT prefixes.id FROM prefixes WHERE calls.destination LIKE prefixes.prefix + '%' ORDER BY length(prefixes.prefix) DESC LIMIT 1) AS prefix_id FROM calls WHERE) AS data GROUP BY data.direction, data.prefix_id

как то так или типа того

Исходная версия exception13, :

prefixes (id, prefix, description);
calls (..., direction, timestamp, destination,...);

SELECT data.direction, data.prefix_id, count(*) FROM (SELECT *, (SELECT prefixes.id FROM prefixes WHERE calls.destination LIKE prefixes.prefix + '%' ORDER BY length(prefixes.destination) DESC LIMIT 1) AS prefix_id FROM calls WHERE) AS data GROUP BY data.direction, data.prefix_id

как то так или типа того