edición general
--626322--

--626322--

En menéame desde noviembre de 2019

6,00 Karma
66K Ranking
Enviadas
Publicadas
Comentarios
Notas
[2024-05-26 03:52:31] 
    SELECT  SQL_NO_CACHE post_id as id, post_user_id as author, post_is_admin as admin, user_login as username, user_karma, user_level as user_level, post_randkey as randkey, post_votes as votes, post_karma as karma, post_ip_int as ip, user_avatar as avatar, post_content as content, UNIX_TIMESTAMP(posts.post_date) as date, favorite_link_id as favorite, vote_value as voted, media.size as media_size, media.mime as media_mime, media.extension as media_extension, media.access as media_access, UNIX_TIMESTAMP(media.date) as media_date, 1 as `read`, admin_posts.admin_user_id as admin_user_id, admin_posts.admin_user_login as admin_user_login FROM posts
    LEFT JOIN users on (user_id = post_user_id)
    LEFT JOIN admin_posts on (admin_posts.admin_post_id = post_id)
    LEFT JOIN favorites ON (@user_id > 0 and favorite_user_id = @user_id and favorite_type = 'post' and favorite_link_id = post_id)
    LEFT JOIN votes ON (post_date > @enabled_votes and @user_id > 0 and vote_type='posts' and vote_link_id = post_id and vote_user_id = @user_id)
    LEFT JOIN media ON (media.type='post' and media.id = post_id and media.version = 0) 
    INNER JOIN (
        SELECT post_id
        
    FROM posts, friends
    WHERE (
        friend_type = "manual"
        AND friend_from = "626322"
        AND friend_to = post_user_id
        AND friend_value > 0
    )

        ORDER BY post_id DESC
        LIMIT 0, 25
    ) AS `id`
    USING (post_id);
: string(37) "Table 'meneame.friends' doesn't exist"

/var/www/meneame-peta/releases/latest/www/libs/rgdb.php#212 (dd)
/var/www/meneame-peta/releases/latest/www/libs/rgdb.php#237 (RGDB->print_error)
/var/www/meneame-peta/releases/latest/www/libs/rgdb.php#350 (RGDB->query)
/var/www/meneame-peta/releases/latest/www/user/notes/notes_friends.php#39 (RGDB->get_results)
/var/www/meneame-peta/releases/latest/www/user/index.php#205 (require)
/var/www/meneame-peta/releases/latest/www/dispatcher.php#138 (include)