-- SQL code:

CREATE TABLE IF NOT EXISTS visit
    (
       id int auto_increment not null,
       engine_id int,
       ip int,
       date date,
       primary key  (id)
    );

CREATE TABLE IF NOT EXISTS search_engine
    (
       id int auto_increment not null,
       useragent int,
       name char(256),
       homepage char(256)
    );

##</code><code>##

select distinct search_engine.id from search_engine
  inner join visit on search_engine.id = visit.engine_id
order by visit.date desc
limit 10;

##</code><code>##

select distinct search_engine.id from search_engine
  inner join (select visit.id from visit order by visit.date desc limit 10);