STAVOPROJEKT Olomouc a.s.

SELECT po.id AS item, date, title, anotation, pi.id AS pict FROM portfolio AS po INNER JOIN pictures AS pi ON pi.item_id = po.id AND pi.section='portfolio' ORDER BY po.date DESC, pi.sequence DESC LIMIT 0,1000