SQL: [2707] (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_news n INNER JOIN sm2_wall_news w ON n.news_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE n.place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_article a INNER JOIN sm2_wall_article w ON a.article_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE a.place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_wall_reviews w INNER JOIN sm2_review_place r ON r.review_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE r.place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_event w INNER JOIN sm2_place_event e ON e.place_event_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE e.place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_place w INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE w.action_id = 2 and w.source_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_placeforum w INNER JOIN sm2_forum_thread f ON f.thread_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE w.action_id = 1 and f.thread_place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_placeforum w INNER JOIN sm2_forum_thread_post p ON p.post_id = w.source_id INNER JOIN sm2_forum_thread f ON f.thread_id = p.thread_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE w.action_id = 2 and f.thread_place_id = :place GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_user_image i INNER JOIN sm2_place_album a ON a.place_album_id = i.source_id INNER JOIN sm2_wall_photo w ON (i.srcfile_id = w.source_id or w.source_id LIKE CONCAT('%,',i.srcfile_id,'%') or w.source_id LIKE CONCAT('%',i.srcfile_id,',%')) INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE :type WHERE a.place_id = :user and w1.user_id = :user GROUP BY w1.wall_id) ORDER BY wall_date DESC LIMIT 0,20 Sent SQL: [2733] (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_news n INNER JOIN sm2_wall_news w ON n.news_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE n.place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_article a INNER JOIN sm2_wall_article w ON a.article_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE a.place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_wall_reviews w INNER JOIN sm2_review_place r ON r.review_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE r.place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_event w INNER JOIN sm2_place_event e ON e.place_event_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE e.place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_place w INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE w.action_id = 2 and w.source_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_placeforum w INNER JOIN sm2_forum_thread f ON f.thread_id = w.source_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE w.action_id = 1 and f.thread_place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, w.action_id as action FROM sm2_wall_placeforum w INNER JOIN sm2_forum_thread_post p ON p.post_id = w.source_id INNER JOIN sm2_forum_thread f ON f.thread_id = p.thread_id INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE w.action_id = 2 and f.thread_place_id = 2202 GROUP BY w1.wall_id) UNION (SELECT w.wall_id, w.source_id, w1.wall_date, w1.user_id, w1.wall_type, null as action FROM sm2_user_image i INNER JOIN sm2_place_album a ON a.place_album_id = i.source_id INNER JOIN sm2_wall_photo w ON (i.srcfile_id = w.source_id or w.source_id LIKE CONCAT('%,',i.srcfile_id,'%') or w.source_id LIKE CONCAT('%',i.srcfile_id,',%')) INNER JOIN sm2_wall w1 ON w.wall_id = w1.wall_id and w1.wall_type LIKE 'articles' WHERE a.place_id = 62941 and w1.user_id = 62941 GROUP BY w1.wall_id) ORDER BY wall_date DESC LIMIT 0,20 Params: 3 Key: Name: [5] :user paramno=-1 name=[5] ":user" is_param=1 param_type=1 Key: Name: [6] :place paramno=-1 name=[6] ":place" is_param=1 param_type=1 Key: Name: [5] :type paramno=-1 name=[5] ":type" is_param=1 param_type=2 Сайт мам Николаева, форум николаевских мам, николаевский сайт Мама
Вы должны авторизироваться чтобы просматривать эту страницу

Приветствуем вас на крупнейшей социальной сети для родителей в нашем городе!
Для того чтобы вы смогли получить доступ к большинству разделов и сервисов на нашем сайте вам необходимо зарегистрироваться или войти на сайт если вы уже зарегистрированы.

Предлагаем вам ознакомится с пошаговой инструкцией как зарегистрироваться на сайте Мама.