search

search.sql

SELECT
        * 
    FROM
        ((SELECT
            uid,
            users.dating_name,
            users.vip,
            users.city_id,
            users.country_id,
            users.dating_year_of_birthy,
            users.dating_month_of_birthy,
            users.dating_birthday,
            users.dating_not_show_to_friends,
            users.photo_id,
            users.photo_url 
        FROM
            users 
        WHERE
            (
                uid != 465157304
            ) 
            AND (
                users.dating_year_of_birthy >= 1962
            ) 
            AND (
                users.dating_year_of_birthy <= 1976
            ) 
            AND (
                users.dating_sex = 1
            ) 
            AND (
                users.country_id = 1
            ) 
            AND (
                users.city_id = 2
            ) 
            AND (
                (
                    users.dating_top_sympathy > 0
                )
            ) 
            AND (
                uid IN (
                    SELECT
                        dating_search_settings.uid 
                    FROM
                        dating_search_settings 
                    WHERE
                        (
                            (
                                users.dating_sex = 2
                            ) 
                            AND (
                                dating_search_settings.country_id = 1
                            ) 
                            AND (
                                dating_search_settings.city_id = 2
                            )
                        ) 
                        AND (
                            dating_search_settings.range_age_start <= 50
                        ) 
                        AND (
                            dating_search_settings.range_age_end >= 50
                        )
                )
            ) 
        ORDER BY
            users.dating_top_start DESC LIMIT 500) 
        UNION
        (
            SELECT
                uid,
                users.dating_name,
                users.vip,
                users.city_id,
                users.country_id,
                users.dating_year_of_birthy,
                users.dating_month_of_birthy,
                users.dating_birthday,
                users.dating_not_show_to_friends,
                users.photo_id,
                users.photo_url 
            FROM
                users 
            WHERE
                (
                    uid != 465157304
                ) 
                AND (
                    users.dating_year_of_birthy >= 1962
                ) 
                AND (
                    users.dating_year_of_birthy <= 1976
                ) 
                AND (
                    users.dating_sex = 1
                ) 
                AND (
                    users.country_id = 1
                ) 
                AND (
                    users.city_id = 2
                ) 
                AND (
                    (
                        users.dating_top_end < 1519636282
                    ) 
                    AND (
                        users.dating_top_sympathy = 0
                    )
                ) 
            ORDER BY
                users.dating_rate DESC LIMIT 500
        ) 
    UNION
    DISTINCT (SELECT
        uid,
        users.dating_name,
        users.vip,
        users.city_id,
        users.country_id,
        users.dating_year_of_birthy,
        users.dating_month_of_birthy,
        users.dating_birthday,
        users.dating_not_show_to_friends,
        users.photo_id,
        users.photo_url 
    FROM
        users 
    WHERE
        (uid != 465157304) 
        AND (users.dating_year_of_birthy >= 1962) 
        AND (users.dating_year_of_birthy <= 1976) 
        AND (users.dating_sex = 1) 
        AND (users.country_id = 1) 
        AND (users.city_id = 2) 
        AND ((users.dating_top_end > 1519636282)) 
        AND (uid IN (SELECT
            dating_search_settings.uid 
        FROM
            dating_search_settings 
        WHERE
            ((users.dating_sex = 2) 
            AND (dating_search_settings.country_id = 1) 
            AND (dating_search_settings.city_id = 2)) 
            AND (dating_search_settings.range_age_start <= 50) 
            AND (dating_search_settings.range_age_end >= 50))) 
    ORDER BY
        users.dating_top_start DESC LIMIT 500)
) AS a 
WHERE
uid NOT IN (
    SELECT
        dating_views.owner 
    FROM
        dating_views 
    WHERE
        (
            dating_views.uid = 465157304
        ) 
        AND (
            dating_views.time > 1519549882
        )
) LIMIT 500