Search Members - Date.Mom development - Meet single moms & nice moms - 100% Free dating & social network

/*search.php query*/ ( SELECT userID, 'u' AS u_or_g, screen_name, howmanypics, gender, registration_time, last_page_load_time, official_picID, official_picserver, howmanyfavorers, last_sent_message_time, last_received_message_time, total_sent_messages, total_received_messages, want_man, want_woman, want_couple_man_and_woman, want_couple_2_man, want_couple_2_woman, want_group, want_ts_tv_tg, want_friends, want_casual, want_long_term, want_webcam, last_heartbeat, about_me, howmanypics_withnudity, official_picID_withnudity, official_picserver_withnudity, howmanypics_audited, official_picID_audited, official_picserver_audited, (6371 * (2 * ATAN2(SQRT(SIN(RADIANS(latitude - 39.9627)/2) * SIN(RADIANS(latitude - 39.9627)/2) + COS(RADIANS(39.9627)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.006)/2) * SIN(RADIANS(longitude - -83.006)/2)), SQRT(1-(SIN(RADIANS(latitude - 39.9627)/2) * SIN(RADIANS(latitude - 39.9627)/2) + COS(RADIANS(39.9627)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.006)/2) * SIN(RADIANS(longitude - -83.006)/2)))))) AS distance, latitude, longitude, instance_number, howmanypics_all, phone_number_validated, country_code, city, (last_heartbeat > 1771594658) AS is_online, (howmanypics >= 1) AS has_pics, premium FROM users WHERE userID != '' && howmanypics >= '0' && interests LIKE '%c%' && validationkey = '1' && hidden != '1' && hidden != '2' && fake != '1' && (instance_number=8 || ((((gender='woman') && (have_children='1' || have_children='3')) || ((want_woman='1') && (date_with_children='1'))))) && instance_number in (1,6,7,8,9,10,11,12,13,14,15,200,201,300) ) UNION ALL ( SELECT guestID, 'g' AS u_or_g, screen_name, howmanypics, gender, creation_time, last_page_load_time, official_picID, official_picserver, howmanyfavorers, last_sent_message_time, last_received_message_time, total_sent_messages, total_received_messages, want_man, want_woman, want_couple_man_and_woman, want_couple_2_man, want_couple_2_woman, want_group, want_ts_tv_tg, want_friends, want_casual, want_long_term, want_webcam, last_heartbeat, about_me, howmanypics_withnudity, official_picID_withnudity, official_picserver_withnudity, howmanypics_audited, official_picID_audited, official_picserver_audited, (6371 * (2 * ATAN2(SQRT(SIN(RADIANS(latitude - 39.9627)/2) * SIN(RADIANS(latitude - 39.9627)/2) + COS(RADIANS(39.9627)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.006)/2) * SIN(RADIANS(longitude - -83.006)/2)), SQRT(1-(SIN(RADIANS(latitude - 39.9627)/2) * SIN(RADIANS(latitude - 39.9627)/2) + COS(RADIANS(39.9627)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.006)/2) * SIN(RADIANS(longitude - -83.006)/2)))))) AS distance, latitude, longitude, instance_number, howmanypics_all, 0 AS phone_number_validated, country_code, city, (last_heartbeat > 1771594658) AS is_online, (howmanypics >= 1) AS has_pics, 0 AS premium FROM guests WHERE last_heartbeat != 0 && guestID != '32124408' && howmanypics >= '0' && interests LIKE '%c%' && hidden != '1' && hidden != '2' && fake != '1' && last_heartbeat != '0' && (instance_number=8 || ((((gender='woman') && (have_children='1' || have_children='3')) || ((want_woman='1') && (date_with_children='1'))))) && instance_number in (1,6,7,8,9,10,11,12,13,14,15,200,201,300) ) ORDER BY distance, is_online DESC, has_pics DESC, last_sent_message_time DESC, last_page_load_time DESC LIMIT 500, 25