Unnamed

SELECT p.num AS number, p.cardID as voipNumber,gx.description AS description, ip.dialstring,
    IF(ip.category = 'F', 'FORWARD',LEFT(ip.dialstring, 3)) AS routingType,
    IF(ip.category = 'F', SUBSTRING_INDEX(dialstring, '|', -1),NULL) AS forwardNumber,
    IF(ip.category = 'FAX', SUBSTRING(dialstring, 5),NULL) AS forwardEmail
  FROM callingcard.pstnnum p
    LEFT JOIN callingcard.incomingnum i ON (p.num = i.number)
    LEFT JOIN callingcard.incomingnum_dp ip ON (ip.id = i.id)
    LEFT JOIN store.geographic_numbers gx ON ( LEFT(p.num,LENGTH(gx.prefix)) = gx.prefix )
  WHERE p.num LIKE '%' LIMIT 50;