Error in Selection Query
SELECT R.*, L.added_date FROM (SELECT * FROM tbl_tab_content_list WHERE flag='1') AS L JOIN (select p.*,c.*, u.username, u.password, u.lname, u.gender, u.dob, u.company, u.street, u.phone, u.fax, u.country, u.zip, u.email, u.pay_email, u.paypal_email, u.money_order, u.check_out, u.date, u.active_code, u.active, u.status, s.state_id, s.state_name FROM tbl_product p left join tbl_state s on p.state=s.state_id left join tbl_city c on p.city=c.city_id right join tbl_user u on u.user_id=p.user_id where p.product_id IS NOT NULL) AS R ON L.product_id=R.product_id ORDER BY L.added_date DESC LIMIT 0, 16
Can't create/write to file '/tmp/#sql_388_2.MYD' (Errcode: 17)