Select catalog_properties.* from catalog_properties, catalog_values, catalog where catalog_properties.id=catalog_values.idp and catalog.id=catalog_values.idc and catalog.category=6 group by catalog_properties.id

---

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