Search Members - Palcity development - Find your new friends!

/var/www/html/2meet4free/dev/2meet4free_git/new/search.php:18:string '$mode' (length=5)

/var/www/html/2meet4free/dev/2meet4free_git/new/search.php:18:string 'html' (length=4)

Coords are used for search: 39.9623 -83.0062
$goforkilometers is: ∞
is not thin coordinates query
query:

/*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.9623)/2) * SIN(RADIANS(latitude - 39.9623)/2) + COS(RADIANS(39.9623)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.0062)/2) * SIN(RADIANS(longitude - -83.0062)/2)), SQRT(1-(SIN(RADIANS(latitude - 39.9623)/2) * SIN(RADIANS(latitude - 39.9623)/2) + COS(RADIANS(39.9623)) * COS(RADIANS(latitude)) * SIN(RADIANS(longitude - -83.0062)/2) * SIN(RADIANS(longitude - -83.0062)/2)))))) AS distance,
    latitude,
    longitude,
    instance_number,
    howmanypics_all,
    phone_number_validated,
    country_code,
    city,
    (last_heartbeat > 1771595536) AS is_online,
    (howmanypics >= 1) AS has_pics,
    premium
FROM users WHERE
userID != ''


&& howmanypics_audited >= '0'










&& validationkey = '1'
&& hidden != '1'
&& hidden != '2'
 && fake != '1' 
 


 && (instance_number=300 || ((((want_friends='1')) || ((want_long_term='1')))))  && instance_number in (1,6,7,8,9,10,11,12,13,14,15,200,201,300)


 ORDER BY registration_time DESC LIMIT 1075, 25