All pastes #476790 Raw Edit

Untitled

public text v1 · immutable
·published 2007-05-08 10:14 UTC
rendered paste body
SELECT `UserImage`.`id`, `UserImage`.`gallery_id`, `UserImage`.`filename`, `Gallery`.`user_id`, `Gallery`.`title`, `Gallery`.`photos` FROM `user_images` AS `UserImage` LEFT JOIN `galleries` AS `Gallery` ON `UserImage`.`id` = `Gallery`.`id` WHERE MATCH( `UserImage`.`description`, `UserImage`.`title`) AGAINST ('test') ORDER BY `UserImage`.`created` DESC