All pastes #550719 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-06-08 14:46 UTC
rendered paste body
(SELECT homes.*, tags.name AS tag_name FROM homes LEFT JOIN tags ON homes.tag_id = tags.tag_id WHERE `homes`.`member_id` = '1' ORDER BY homes.insert_date DESC)) UNION (SELECT spaces.*, tags.name AS tag_name FROM spaces LEFT JOIN tags ON spaces.tag_id = tags.tag_id WHERE `spaces`.`member_id` = '1' ORDER BY spaces.insert_date DESC) LIMIT 3