hang_qry.sql

SELECT real_efile_f1.repid, real_efile_f1.comid, real_efile_f1.com_name, real_efile_f1.com_str1, real_efile_f1.com_str2, real_efile_f1.com_city, real_efile_f1.com_state, real_efile_f1.com_zip, real_efile_f1.sub_date, real_efile_f1.amend_name, real_efile_f1.amend_address, real_efile_f1.cmte_type, real_efile_f1.canid, real_efile_f1.can_lname, real_efile_f1.can_fname, real_efile_f1.can_mname, real_efile_f1.can_prefix, real_efile_f1.can_suffix, real_efile_f1.office, real_efile_f1.el_state, real_efile_f1.district, real_efile_f1.party, real_efile_f1.party_code, real_efile_f1.lrpac5e, real_efile_f1.lrpac5f, real_efile_f1.lead_pac, real_efile_f1.aff_comid, real_efile_f1.aff_canid, real_efile_f1.ac_name, real_efile_f1.aff_fname, real_efile_f1.aff_mname, real_efile_f1.aff_prefix, real_efile_f1.aff_suffix, real_efile_f1.acstr1, real_efile_f1.acstr2, real_efile_f1.accity, real_efile_f1.acstate, real_efile_f1.aczip, real_efile_f1.relations, real_efile_f1.organ_type, real_efile_f1.affrel_code, real_efile_f1.c_lname, real_efile_f1.c_fname, real_efile_f1.c_mname, real_efile_f1.c_prefix, real_efile_f1.c_suffix, real_efile_f1.str1, real_efile_f1.str2, real_efile_f1.city, real_efile_f1.state, real_efile_f1.zip, real_efile_f1.title, real_efile_f1.phone, real_efile_f1.t_lname, real_efile_f1.t_fname, real_efile_f1.t_mname, real_efile_f1.t_prefix, real_efile_f1.t_suffix, real_efile_f1.tstr1, real_efile_f1.tstr2, real_efile_f1.tcity, real_efile_f1.tstate, real_efile_f1.tzip, real_efile_f1.ttitle, real_efile_f1.tphone, real_efile_f1.d_lname, real_efile_f1.d_fname, real_efile_f1.d_mname, real_efile_f1.d_prefix, real_efile_f1.d_suffix, real_efile_f1.dstr1, real_efile_f1.dstr2, real_efile_f1.dcity, real_efile_f1.dstate, real_efile_f1.dzip, real_efile_f1.dtitle, real_efile_f1.dphone, real_efile_f1.b_lname, real_efile_f1.bstr1, real_efile_f1.bstr2, real_efile_f1.bcity, real_efile_f1.bstate, real_efile_f1.bzip, real_efile_f1.bname_2, real_efile_f1.bstr1_2, real_efile_f1.bstr2_2, real_efile_f1.bcity_2, real_efile_f1.bstate_2, real_efile_f1.bzip_2, real_efile_f1.lname, real_efile_f1.fname, real_efile_f1.mname, real_efile_f1.prefix, real_efile_f1.suffix, real_efile_f1.sign_date, real_efile_f1.amend_email, real_efile_f1.email, real_efile_f1.amend_url, real_efile_f1.url, real_efile_f1.fax, real_efile_f1.imageno, real_efile_f1.create_dt 
FROM real_efile_f1 ORDER BY random() 
 LIMIT %(param_1)s


this query is not returning any rows
even though the limit is 1