Advanced

SELECT * FROM hotornot_params_values

 SELECT hp.id AS photo_id,
                hp.title,
                hp.path2file,
                hp.votes_number,
                hp.mark_average,
                hp.aproved,
                hp.submited_datetime,
                hu.id AS user_id,
                hu.nickname,
                hu.email,
                hp.lastVoteDatetime
            FROM hotornot_photo AS hp 
            LEFT JOIN hotornot_user AS hu ON (hp.hotornot_user_id=hu.id)
            WHERE hp.aproved=1 
                AND ( hp.votes_number = 0 OR ( hp.lastVoteDatetime IS NULL ) OR ((now()-hp.lastVoteDatetime) > 1800))
            ORDER BY votes_number LIMIT 0,1

SELECT hp.id AS photo_id, hv.from_ip
             FROM hotornot_photo AS hp
             LEFT JOIN hotornot_vote AS hv 
                    ON (hv.hotornot_photo_id = hp.id AND hv.from_ip = '38.103.63.18')
             WHERE hp.aproved=1
                AND from_ip IS NULL LIMIT 0,1 

 SELECT hp.id AS photo_id,
                hp.title,
                hp.path2file,
                hp.votes_number,
                hp.mark_average,
                hp.aproved,
                hp.submited_datetime,
                hu.id AS user_id,
                hu.nickname,
                hu.email,
                max(hv.vote_datetime) as lastDatetime 
            FROM hotornot_photo AS hp 
            LEFT JOIN hotornot_user AS hu ON (hp.hotornot_user_id=hu.id)
            LEFT JOIN hotornot_vote AS hv ON (hv.hotornot_photo_id = hp.id)
            WHERE hp.aproved=1 
                AND  hv.from_ip = '38.103.63.18'
            GROUP BY photo_id, title, path2file, votes_number, mark_average, aproved, submited_datetime, user_id, nickname, email
            ORDER BY lastDatetime 
            LIMIT 0,1 

Please select a rating below to view the next picture 1  2  3  4  5  6  7  8  9  10

0.00 based on 0 votes

Submitted by , on

Send this photo to a friend Submit your photo:New User or Login