История изменений
Исправление 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
как то так или типа того