Koberce-Metraz.cz
Error 1054: Unknown column 'nazev' in 'order clause'
SELECT p.*, ip.name AS img, ct.short_name AS typ, cs.name AS spec FROM products p LEFT JOIN img_products ip ON ip.products_id=p.id LEFT JOIN codebook_type ct ON ct.id = p.type_id LEFT JOIN codebook_spec cs ON cs.id = p.spec_id ORDER BY nazev