Resource id #121
select gm_users.user_id, gm_users.date_c date_c, date_l, gm_personal.profile profile, profile_id, FEET, Caste1, Caste2, RESIDINGCITY1,gm_personal.country_living country_living, marital_status, RELIGION, p_dob_date, OTHEREDUCATION, reg_no, photograph, gm_users.email_id, p_gender, residing_city from gm_users, gm_personal, gm_bas_pro_family where gm_users.user_id = gm_personal.user_id AND gm_bas_pro_family.user_id = gm_users.user_id and date_l != "0000-00-00 00:00:00" and ( UNIX_TIMESTAMP()- UNIX_TIMESTAMP(date_l) )/60 < 30 ORDER BY gm_personal.reg_id DESC LIMIT 0, 10