1. SELECT ID FROM lms.lead_source WHERE Title = 'Inhouse CallCenter' AND lead_type = 'Call Center';
  2. SELECT ID FROM lms.lead_source WHERE Title = 'Monitor' AND lead_type = 'NP';
  3. SELECT ID FROM lms.lead_source WHERE Title = 'KASW' AND lead_type = 'TV';
  4. SELECT ID FROM lms.lead_source WHERE Title = 'KBFM-BMW' AND lead_type = 'Radio';
  5. SELECT ID FROM lms.lead_source WHERE Title = 'Brownsville Herald' AND lead_type = 'NP';
  6. SELECT ID FROM lms.lead_source WHERE Title = 'KGBT-BMW' AND lead_type = 'TV';
  7. SELECT ID FROM lms.lead_source WHERE Title = 'KFXV' AND lead_type = 'TV';
  8. SELECT ID FROM lms.lead_source WHERE Title = 'Job Finder' AND lead_type = 'NP';
  9. SELECT ID FROM lms.lead_source WHERE Title = 'KCWT' AND lead_type = 'TV';
  10. SELECT ID FROM lms.lead_source WHERE Title = 'Arizona Republic' AND lead_type = 'NP';
  11. SELECT ID FROM lms.lead_source WHERE Title = 'Thrifty Nickel' AND lead_type = 'NP';
  12. SELECT ID FROM lms.lead_source WHERE Title = 'KKPS-BMW' AND lead_type = 'Radio';
  13. SELECT ID FROM lms.lead_source WHERE Title = 'Ad Sack' AND lead_type = 'NP';
  14. SELECT ID FROM lms.lead_source WHERE Title = 'Sunrise Mall' AND lead_type = 'Other';
  15. SELECT ID FROM lms.lead_source WHERE Title = 'Town Crier' AND lead_type = 'NP';
  16. SELECT ID FROM lms.lead_source WHERE Title = 'Job Examiner' AND lead_type = 'NP';
  17. SELECT ID FROM lms.lead_source WHERE Title = 'KRGV' AND lead_type = 'TV';
  18. SELECT ID FROM lms.lead_source WHERE Title = 'KNVO' AND lead_type = 'TV';
  19. SELECT ID FROM lms.lead_source WHERE Title = 'XRIO' AND lead_type = 'TV';
  20. SELECT ID FROM lms.lead_source WHERE Title = 'Z 95' AND lead_type = 'Radio';
  21. SELECT ID FROM lms.lead_source WHERE Title = 'KVEO' AND lead_type = 'TV';
  22. SELECT ID FROM lms.lead_source WHERE Title = 'Planet 102.3' AND lead_type = 'Radio';
  23. SELECT ID FROM lms.lead_source WHERE Title = 'KTFV' AND lead_type = 'TV';
  24. SELECT ID FROM lms.lead_source WHERE Title = 'KVLY-BMW' AND lead_type = 'Radio';
  25. SELECT ID FROM lms.lead_source WHERE Title = 'Website' AND lead_type = 'Website';
  26. SELECT ID FROM lms.lead_source WHERE Title = 'XERV' AND lead_type = 'TV';
  27. SELECT ID FROM lms.lead_source WHERE Title = 'Roddin & Racin' AND lead_type = 'TV';
  28. SELECT ID FROM lms.lead_source WHERE Title = 'Facebook' AND lead_type = 'Social';
  29. SELECT ID FROM lms.lead_source WHERE Title = 'KAZT' AND lead_type = 'TV';
  30. SELECT ID FROM lms.lead_source WHERE Title = 'Cox Cable' AND lead_type = 'TV';
  31. SELECT ID FROM lms.lead_source WHERE Title = 'Event Goodies' AND lead_type = '';
  32. SELECT ID FROM lms.lead_source WHERE Title = 'Billboard' AND lead_type = 'Other';
  33. SELECT ID FROM lms.lead_source WHERE Title = 'KABB' AND lead_type = 'TV';
  34. SELECT ID FROM lms.lead_source WHERE Title = 'Bargain Book' AND lead_type = 'NP';
  35. SELECT ID FROM lms.lead_source WHERE Title = 'KDF' AND lead_type = 'TV';
  36. SELECT ID FROM lms.lead_source WHERE Title = 'Time Warner Cable' AND lead_type = 'TV';
  37. SELECT ID FROM lms.lead_source WHERE Title = 'KUQI' AND lead_type = 'TV';
  38. SELECT ID FROM lms.lead_source WHERE Title = 'NRIS' AND lead_type = 'TV';
  39. SELECT ID FROM lms.lead_source WHERE Title = 'KTOV' AND lead_type = 'TV';
  40. SELECT ID FROM lms.lead_source WHERE Title = 'KRIS' AND lead_type = 'TV';
  41. SELECT ID FROM lms.lead_source WHERE Title = 'KZTV' AND lead_type = 'TV';
  42. SELECT ID FROM lms.lead_source WHERE Title = 'Klll' AND lead_type = 'TV';
  43. SELECT ID FROM lms.lead_source WHERE Title = 'Greensheet' AND lead_type = 'NP';
  44. SELECT ID FROM lms.lead_source WHERE Title = 'Kbay 92.7' AND lead_type = 'Radio';
  45. SELECT ID FROM lms.lead_source WHERE Title = 'MundoFox' AND lead_type = 'TV';
  46. SELECT ID FROM lms.lead_source WHERE Title = 'Job News' AND lead_type = 'NP';
  47. SELECT ID FROM lms.lead_source WHERE Title = 'KMYS' AND lead_type = 'TV';
  48. SELECT ID FROM lms.lead_source WHERE Title = 'Time Warner Cable' AND lead_type = 'SA';
  49. SELECT ID FROM lms.lead_source WHERE Title = 'XHAB' AND lead_type = 'TV';
  50. SELECT ID FROM lms.lead_source WHERE Title = 'High School' AND lead_type = 'Other';

SELECT * FROM [BERT].[leadcapture].[LeadSource] WHERE name IN ('Inhouse CallCenter','Monitor','KASW','KBFM-BMW','Brownsville Herald','KGBT-BMW','KFXV','Job Finder','KCWT','Arizona Republic','Thrifty Nickel','KKPS-BMW','Ad Sack','Sunrise Mall','Town Crier','Job Examiner','KRGV','KNVO','XRIO','Z 95','KVEO','Planet 102.3','KTFV','KVLY-BMW','Website','XERV','Roddin & Racin','Facebook','KAZT','Cox Cable','Event Goodies','Billboard','KABB','Bargain Book','KDF','Time Warner Cable','KUQI','NRIS','KTOV','KRIS','KZTV','Klll','Greensheet','Kbay 92.7','MundoFox','Job News','KMYS','Time Warner Cable','XHAB','High School','0');

Count should be: 50