1114 The table '/var/mysqltmp/#sql_bc8a7_50' is full
in:
[SELECT DISTINCT p.products_type, p.products_id,p.products_part_number, pd.products_name,pd.products_description, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name, p.products_model, p.products_quantity, p.products_weight, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status, p.master_categories_id, m.manufacturers_id FROM products p LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id) left join products_to_categories p2c on p.products_id = p2c.products_id left join products_description pd on p.products_id = pd.products_id join products_attributes p2a on p.products_id = p2a.products_id join products_options po on p2a.options_id = po.products_options_id join products_options_values pov on p2a.options_values_id = pov.products_options_values_id WHERE p.products_status = 1 AND (p.products_date_available IS NULL OR p.products_date_available <= current_date) AND pd.language_id = 1 GROUP BY p.products_id having ( true and ( false or FIND_IN_SET("98", GROUP_CONCAT(distinct p2a.options_values_id)))) order by p.products_sort_order asc, p.products_id desc limit 20, 10]