nozzy

$book = Book::where('author', $author)->firstOrFail();

WHERE macvalue >= NOW() - INTERVAL 1 HOUR
GROUP BY hour(macvalue)

WHERE FROM_UNIXTIME(VisitTime) >= NOW() - INTERVAL 1 HOUR
GROUP BY hour(FROM_UNIXTIME(VisitTime))

SELECT * FROM messages
WHERE receiver = 1
ORDER BY date DESC LIMIT 1

select t1.*, t2.*
from (select * from class_ads where class_ads.active=1) as t1
inner join (select * from class_slugs where class_slugs.`type`='listing') as t2 on t1.id = t2.object_id

SELECT * FROM table WHERE id IN (SELECT CONCAT_WS( ",", id1, id2 ) FROM table2)

SELECT SUBSTRING_INDEX('some-text||movie_id,bla-bla', '||movie_id', 1) AS xfields;

....
ORDER BY sv DESC LIMIT 10

SELECT * FROM T
WHERE id = '$curUserId'
UNION
SELECT * FROM T
WHERE id <> '$curUserId'
ORDER BY `date` ASC