Construction work for halls of residence.
SELECT distinct poptavky.*, class_cpv.ID, class.ID FROM poptavky left join class_cpv on poptavky.ID=class_cpv.ID left join class on poptavky.ID=class.ID WHERE (poptavky.popis_en<>'')AND(poptavky.druh='1')AND(class_cpv.class LIKE '45214700-7%') order by poptavky.datum DESC
<< Previous page |
Next page >>