Select catalog_props.* from catalog_props, catalog_props_value, catalog where catalog_props.id=catalog_props_value.idp and catalog.id=catalog_props_value.idc and catalog.category=187 group by catalog_props.id order by min(catalog_props_value.pos) asc

---

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