Select catalog_properties.* from catalog_properties, catalog_values, catalog where catalog_properties.id=catalog_values.idp and catalog.id=catalog_values.idc and catalog.cat="413" group by catalog_properties.id

---

Disk full (/tmp/#sql_38b_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")