| 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 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.0123 |
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 * FROM mm_media m
WHERE m.ID_user='11' AND m.publikuj='1' ORDER BY `m`.`data` DESC LIMIT 1
|
| 0.0105 |
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
|
| 0.0106 |
SELECT u.username, u.data_rejestracji, uu.avatar FROM mm_users u
LEFT JOIN mm_userconf uu ON uu.ID_user=u.id
WHERE u.last_media_insert IS NOT NULL
ORDER BY u.id DESC
LIMIT 0,4
|
| 0.0105 |
SELECT m.plik, u.id, u.username, m.nazwa, m.opis, m.weight, m.height, m.data, m.srednia_ocen, m.ID_media, m.typ, m.kod FROM mm_zdjecie_dnia z
LEFT JOIN mm_media m ON m.ID_media=z.ID_media
LEFT JOIN mm_users u ON u.id=m.ID_user
WHERE m.publikuj = '1'
ORDER BY z.data DESC
LIMIT 1
|
| 0.0108 |
SELECT * FROM mm_config_wojewodztwa ORDER BY ID_woj
|
| 0.0106 |
SELECT t.id, t.poster, t.subject, t.posted, t.question, t.last_poster, t.num_replies, p.message
FROM mm_forum_topics t
LEFT JOIN mm_forum_posts p ON p.id = t.last_post_id
WHERE crap = '0' and t.forum_id <> 10 and t.forum_id <> 11
ORDER BY t.last_post DESC
LIMIT 6
|
| 0.0108 |
SELECT m.ID_media, m.nazwa, m.plik, u.username, m.ID_user, m.ocena_z_plusow, uc.haslo_na_bloga
FROM mm_media m
LEFT JOIN mm_zdjecie_dnia z ON z.ID_user = m.ID_user AND `z`.`data` >= now() - INTERVAL 7 DAY
LEFT JOIN mm_users u ON u.id=m.ID_user
LEFT JOIN mm_userconf uc ON uc.ID_user=m.ID_user
WHERE `m`.`data` >= '2012-05-18 20:00:00' AND `m`.`data` <= '2012-05-19 20:00:00'
AND m.`publikuj` = '1'
AND m.typ <> '0'
AND m.czyjefoto <> 'nie-moje'
AND z.ID_zdjecia IS NULL
AND uc.priv_zdjdnia = '1'
ORDER BY `m`.`ocena_z_plusow` DESC
LIMIT 0 , 12
|
| 0.0107 |
SELECT COUNT(m.ID_media) as ile
FROM mm_media m
LEFT JOIN mm_zdjecie_dnia z ON z.ID_user = m.ID_user AND `z`.`data` >= '2012-05-14'
LEFT JOIN mm_users u ON u.id=m.ID_user
LEFT JOIN mm_userconf uc ON uc.ID_user=m.ID_user
WHERE `m`.`data` >= '2012-05-18 20:00:00' AND `m`.`data` <= '2012-05-19 20:00:00'
AND m.`publikuj` = '1'
AND m.typ <> '0'
AND m.czyjefoto <> 'nie-moje'
AND z.ID_zdjecia IS NULL
AND uc.priv_zdjdnia = '1'
ORDER BY `m`.`ocena_z_plusow` DESC
|
miejsce na zdjęcia, bez limitów
