1021 Disk full (/var/tmp/#sql_544_0); waiting for someone to free some space...
in:
[select pov.products_options_values_id, pov.products_options_values_name, pa.* from zen_products_attributes pa, zen_products_options_values pov where pa.products_id = '2653' and pa.options_id = '1' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '1' order by LPAD(pa.products_options_sort_order,11,"0"), pov.products_options_values_name]