Code: Select all
SELECT `best`.* FROM (SELECT `id` FROM `best` ORDER BY RAND() LIMIT 10) AS `random_best` LEFT JOIN `best` ON `best`.`id` = `random_best`.`id`;Code: Select all
best = id, event_id, image
events = id, school_id, ...Code: Select all
SELECT `best`.*,`events`.`id`,`events`.`school_id` FROM (SELECT `id` FROM `best` ORDER BY RAND() LIMIT 10) AS `random_best`, `events` LEFT JOIN `best` ON `best`.`id` = `random_best`.`id` LEFT JOIN `best` ON `best`.`event_id` = `events`.`id` WHERE `events`.`school_id`='$school_id';
#OR more clearly:
SELECT `best`.*,
`events`.`id`,`events`.`school_id`
FROM (SELECT `id` FROM `best` ORDER BY RAND() LIMIT 10) AS `random_best`,
`events`
LEFT JOIN `best` ON `best`.`id` = `random_best`.`id`
LEFT JOIN `best` ON `best`.`event_id` = `events`.`id`
WHERE `events`.`school_id`='$school_id';Help!