SELECT
    COUNT( DISTINCT( lead.id ) )
FROM lead WHERE lead.id IS NOT NULL
AND (  ( lead.fname IS NOT NULL AND lead.fname <> ? )  OR  ( lead.lname IS NOT NULL AND lead.lname <> ? )  )
AND  lead.id IN ( SELECT lead_phone.lead_id FROM lead_phone LEFT JOIN phone ON lead_phone.phone_id = phone.id WHERE phone.valid = :phone_valid )
AND  lead.id IN ( SELECT lead_phone.lead_id FROM lead_phone LEFT JOIN phone ON lead_phone.phone_id = phone.id WHERE phone.line_type IN ( ?,? ) )
AND  lead.id IN ( SELECT email_lead.lead_id FROM email_lead LEFT JOIN email ON email_lead.email_id = email.id WHERE email.valid_domain = :email_valid_domain )
AND  lead.country IN ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
AND  lead.id IN ( SELECT lead_tag.lead_id FROM lead_tag LEFT JOIN tag ON lead_tag.tag_id = tag.id WHERE tag.tag LIKE :tag_tag )
AND  lead.fname <> :lead_fname

SELECT
    DISTINCT( lead.id )
FROM lead
WHERE lead.id IS NOT NULL
AND (  ( lead.fname IS NOT NULL AND lead.fname <> '' )  OR  ( lead.lname IS NOT NULL AND lead.lname <> '' )  )
AND  lead.id IN ( SELECT lead_phone.lead_id FROM lead_phone LEFT JOIN phone ON lead_phone.phone_id = phone.id WHERE phone.valid = '1' )
AND  lead.id IN ( SELECT lead_phone.lead_id FROM lead_phone LEFT JOIN phone ON lead_phone.phone_id = phone.id WHERE phone.line_type IN ( 'mobile','landline_or_mobile' ) )
AND  lead.id IN ( SELECT email_lead.lead_id FROM email_lead LEFT JOIN email ON email_lead.email_id = email.id WHERE email.valid_domain = '1' )
AND  lead.country IN ( 'AU','AT','CA','DK','FO','FI','DE','GL','HK','IS','IE','IT','JM','KW','LI','LU','MY','MC','NL','AN','NZ','NF','NO','PT','QA','SA','SG','ZA','ES','SE','CH','AE','GB','AX' )
AND  lead.id IN ( SELECT lead_tag.lead_id FROM lead_tag LEFT JOIN tag ON lead_tag.tag_id = tag.id WHERE tag.tag LIKE '%Binary%' )
AND  lead.fname <> 'None'  GROUP BY lead.id ORDER BY id ASC

SELECT
    *
FROM lead l  (  ( lead.fname IS NOT NULL AND lead.fname <> ? )  OR  ( lead.lname IS NOT NULL AND lead.lname <> ? )  )
AND  lead.country IN ( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )
AND  lead.id IN ( SELECT lead_tag.lead_id FROM lead_tag LEFT JOIN tag ON lead_tag.tag_id = tag.id WHERE tag.tag LIKE :tag_tag )
AND  lead.fname <> :lead_fname

AND exists( SELECT lead_phone.lead_id FROM lead_phone LEFT JOIN phone ON lead_phone.phone_id = phone.id WHERE  l.id=lead_phone.lead_id  and phone.valid = :phone_valid and phone.line_type IN ( ?,? ))

AND  exists ( SELECT email_lead.lead_id FROM email_lead LEFT JOIN email ON email_lead.email_id = email.id
WHERE l.id=email_lead.lead_id and   email.valid_domain = :email_valid_domain )

SELECT DISTINCT( lead.id )
    FROM  lead
    WHERE  lead.id IS NOT NULL
      AND  ( ( lead.fname IS NOT NULL
                      AND  lead.fname <> '' )
              OR  ( lead.lname IS NOT NULL
                      AND  lead.lname <> '' )
           )
      AND  lead.id IN (
        SELECT  lead_phone.lead_id
            FROM  lead_phone
            LEFT JOIN  phone  ON lead_phone.phone_id = phone.id
            WHERE  phone.valid = '1'
                      )
      AND  lead.id IN (
        SELECT  lead_phone.lead_id
            FROM  lead_phone
            LEFT JOIN  phone  ON lead_phone.phone_id = phone.id
            WHERE  phone.line_type IN ( 'mobile','landline_or_mobile' )
                      )
      AND  lead.id IN (
        SELECT  email_lead.lead_id
            FROM  email_lead
            LEFT JOIN  email  ON email_lead.email_id = email.id
            WHERE  email.valid_domain = '1'
                      )
      AND  lead.country IN ( 'AU','AT','CA','DK','FO','FI','DE',
                'GL','HK','IS','IE','IT','JM','KW','LI','LU','MY','MC',
                'NL','AN','NZ','NF','NO','PT','QA','SA','SG','ZA','ES',
                'SE','CH','AE','GB','AX'
                          )
      AND  lead.id IN (
        SELECT  lead_tag.lead_id
            FROM  lead_tag
            LEFT JOIN  tag  ON lead_tag.tag_id = tag.id
            WHERE  tag.tag LIKE '%Binary%'
                      )
      AND  lead.fname <> 'None'
    GROUP BY  lead.id
    ORDER BY  id ASC