| 0.0109 |
SELECT m.plik, m.typ, m.nazwa, m.ID_media, m.opis, m.min_w, m.min_h, m.kod,
u.username, u.gender, m.data, uu.avatar, uu.haslo_na_bloga, u.ID_pakiet
FROM mm_users u
LEFT JOIN mm_media m ON m.ID_media=u.last_id_media
LEFT JOIN mm_userconf uu ON uu.ID_user=u.id
WHERE u.last_media_insert > DATE_SUB(NOW(), INTERVAL 24 HOUR)
AND u.crap='0'
AND m.ID_media IS NOT NULL
AND uu.haslo_na_bloga = ''
AND m.czyjefoto = 'zrobione-przezemnie'
ORDER BY u.last_media_insert DESC
LIMIT 0, 9
|
| 0.0108 |
SELECT m.plik, m.typ, m.nazwa, m.ID_media, m.opis, m.min_w, m.min_h, m.kod,
u.username, u.gender, m.data, uu.avatar, uu.haslo_na_bloga, u.ID_pakiet
FROM mm_users u
LEFT JOIN mm_media m ON m.ID_media=u.last_id_media
LEFT JOIN mm_userconf uu ON uu.ID_user=u.id
WHERE u.last_media_insert > DATE_SUB(NOW(), INTERVAL 30 DAY)
AND u.crap='0'
AND m.ID_media IS NOT NULL
AND u.ID_pakiet > '1'
AND uu.haslo_na_bloga = ''
and m.czyjefoto = 'zrobione-przezemnie'
ORDER BY u.last_media_insert DESC
LIMIT 0,14
|
| 0.0113 |
SELECT * FROM
(
SELECT ID_kom, k.tresc, u.username, m.ID_media, m.nazwa, uc.avatar, u2.username as profil, k.nick FROM mm_komentarze k
LEFT OUTER JOIN mm_users u ON u.id=k.ID_user
LEFT OUTER JOIN mm_media m ON m.ID_media=k.ID_media
LEFT OUTER JOIN mm_userconf uc ON uc.ID_user=k.ID_user
LEFT OUTER JOIN mm_users u2 ON u2.id=m.ID_user
WHERE k.moderuj='0'
ORDER BY k.ID_kom DESC
LIMIT 0,50
) as t
GROUP BY t.profil
ORDER BY t.ID_kom DESC
LIMIT 0,10
|
| 0.0107 |
SELECT u.username, uc.avatar, u.all_views FROM mm_users u
LEFT OUTER JOIN mm_userconf uc ON u.id=uc.ID_user
WHERE u.status = '1'
ORDER BY u.last_activity DESC
LIMIT 16
|
Blog na Twoje fotki
miejsce na zdjęcia, bez limitów