SQL test

Sql code posted by Bart
created at 20 Jan 18:52

Edit | Back 
1
2
3
4
 
      (SELECT effect, koers, datum FROM koers WHERE datum <= '2011-01-19' AND effect = 1 AND deleted = 0 ORDER BY datum DESC LIMIT 1) 
UNION (SELECT effect, koers, datum FROM koers WHERE datum <= '2011-01-19' AND effect = 2 AND deleted = 0 ORDER BY datum DESC LIMIT 1) 
UNION (SELECT effect, koers, datum FROM koers WHERE datum <= '2011-01-19' AND effect = 3 AND deleted = 0 ORDER BY datum DESC LIMIT 1) 
UNION ...
419 Bytes in 2 ms with coderay