Untitled

Combining three mysql statements
SELECT pageid FROM thepage WHERE DATE(createdate)='2011-11-09' ORDER BY createdate DESC

SELECT urlid FROM themix WHERE pageid=...

SELECT link FROM theurl WHERE urlid=...

SELECT p.pageid
     , u.link
FROM thepage p INNER JOIN themix m
    ON p.pageid = m.pageid
INNER JOIN theurl u
    ON m.urlid = u.urlid
WHERE DATE(p.createdate) = '2011-11-09'
ORDER BY p.createdate DESC

SELECT u.link
FROM thepage p
  INNER JOIN themix m
    ON p.pageid = m.pageid
  INNER JOIN theurl u
    ON m.urlid = u.urlid
WHERE DATE(p.createdate) = '2011-11-09'
GROUP BY m.urlid
ORDER BY MIN(p.createdate) DESC

WHERE DATE(p.createdate) = '2011-11-09'

WHERE p.createdate = '2011-11-09'

WHERE p.createdate >= '2011-11-09'
  AND p.createdate < '2011-11-10'

SELECT url.link
FROM page
  INNER JOIN mix
    ON page.pageid = mix.pageid
  INNER JOIN url
    ON mix.urlid = url.urlid
WHERE DATE(page.createdate) = '2011-11-09'
ORDER BY page.createdate DESC

SELECT
    theurl.link
FROM
    thepage
LEFT JOIN
    themix
ON
    thepage.pageid = urlid.pageid
LEFT JOIN
    theurl
ON
    theurl.urlid = themix.urlid
WHERE
    DATE(thepage.createdate)='2011-11-09'
ORDER BY
    thepage.createdate DESC