title: Selective query
body: <p>I'm keeping a database of accesses to a website (origin ip, refrer and landing page) so i can do some analisys of visitors and which pages are more interesting and wich need work (amongst other things)</p>
  
  <p>Now some visitor IPs don't interest me much - like google's or microsoft's robots that i have identified, or my company's own ip (we have static IP for hosting and mail server), so i have a table holding those ips.</p>
  
  <p>I have query's to get the access data both by pages and by date range, however, i need to show the full access history on all IPs except the ones on my excluded IPs table - for those i only want the first access of each day</p>
  
  <p><strong>EDIT:</strong> per request, here's an example of what i need:
  Here's a sample with tables/data (also on <a href="http://sqlfiddle.com/#!9/c21552/1/0" rel="nofollow">sqlfiddler</a>)</p>
  
  <pre><code>create table access (
    id int(11),
    accessDate datetime,
    ip varchar(15),
    referer varchar(150),
    landPage varchar(150)
  );
  create table removed (
    ip varchar(15)
  );
  insert into access (id, accessDate, ip, referer, landPage) values (1, '2015-08-25 12:22:24', '123.123.123.123', 'www.google.com', 'www.mydomain.com');
  insert into access (id, accessDate, ip, referer, landPage) values (2, '2015-08-25 12:25:24', '123.123.123.123', 'www.mydomain.com', 'www.mydomain.com/sub1');
  insert into access (id, accessDate, ip, referer, landPage) values (3, '2015-08-25 13:22:24', '103.123.123.123', 'www.google.com', 'www.mydomain.com');
  insert into access (id, accessDate, ip, referer, landPage) values (4, '2015-08-25 13:23:24', '103.123.123.123', 'www.mydomain.com', 'www.mydomain.com/sub1');
  insert into access (id, accessDate, ip, referer, landPage) values (5, '2015-08-26 12:22:24', '123.123.123.123', 'www.google.com', 'www.mydomain.com');
  insert into removed (ip) values ('123.123.123.123');
  </code></pre>
  
  <p>I need a query that would return something like:</p>
  
  <pre><code>1 2015-08-25 12:22:24 123.123.123.123 www.google.com www.mydomain.com
  3 2015-08-25 13:22:24 103.123.123.123 www.google.com www.mydomain.com
  4 2015-08-25 13:23:24 103.123.123.123 www.mydomain.com www.mydomain.com/sub1
  5 2015-08-26 12:22:24 123.123.123.123 www.google.com www.mydomain.com
  </code></pre>
  
  <p>Basically, it would show all entries for IP 103.123.123.123 since it isn't in table <code>removed</code> while showing only the first entry of IP 123.123.123.123 of each day since it is in table removed.</p>
  
  <p>Is this possible?</p>