CREATE TEMPORARY TABLE tabletemp (

      SELECT

      sites.id AS id1,
      sites.DOMAIN,
      sites.login,
      sites.pass,
      sites.platform,
      sites.theme_id AS theme_id1,
      sites.DATE,

      content_raw.id AS id2,
      content_raw.title,
      content_raw.theme_id AS theme_id2

      FROM sites JOIN content_raw
ON (sites.theme_id=content_raw.theme_id AND content_raw.url_send IS NULL)
);

SELECT id1, DOMAIN, theme_id1, theme_id2, id2, title FROM tabletemp
ORDER BY id1;