SELECT g_id, g_name, g_pic, g_desc, g_price, g_price_currency, g_edizm, g_timestamp, g_kill_date, g_comp_id, g_counter, comp_id, comp_name, comp_reg_type, comp_is_brigada FROM goods,comp,goods2otrasl WHERE comp_id=g_comp_id AND g_kill_date >= NOW() AND g2o_g_id=g_id AND g2o_otrasl_id='404' GROUP BY g_id ORDER BY g_timestamp DESC LIMIT 0,15
Disk full (/var/tmp/#sql_69cd_5); waiting for someone to free some space...