Precious and semi-precious stones; pumice stone; emery; natural abrasives; other minerals and precious metals.
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 '14520000-2%') order by poptavky.datum DESC
<< Previous page |
Next page >>