MySQL Error!
------------------------

The Error returned was:
Can't create/write to file '/tmp/#sql_2e9c_0.MYD' (Errcode: 17)

Error Number:
1

SELECT pr.*, (SELECT img_s_1 from p_photos where p_id = pr.id ORDER BY is_thumb DESC LIMIT 1) AS img_s_1 FROM products AS pr WHERE pr.published_bg = '1' and (is_promo_bg regexp '[[:<:]](429)[[:>:]]' or is_promo_bg regexp '[[:<:]](0)[[:>:]]') ORDER BY RAND() LIMIT 0,6