select 
  `security_blacklisted_country_hits`.*, 
  (
    select 
      display_name 
    from 
      account 
    where 
      account.id_account = security_blacklisted_country_hits.added_by
  ) as added_by_display_name, 
  (
    select 
      name 
    from 
      countries 
    where 
      countries.alpha_2 = security_blacklisted_country_hits.country_code
  ) as country_name 
from 
  `security_blacklisted_country_hits` 
where 
  `country_code` = 'us' 
limit 
  1 offset 0

select 
  * 
from 
  security_hosts_blacklist 
where 
  'ec2-54-161-82-122.compute-1.amazonaws.com' regexp replace(
    replace(
      replace(host_pattern, '-', '\\-'), 
      '.', 
      '\\.'
    ), 
    '*', 
    '.+'
  )

select 
  * 
from 
  security_ips_blacklist 
where 
  '54.161.82.122' regexp replace(
    replace(
      replace(ip, '-', '\\-'), 
      '.', 
      '\\.'
    ), 
    '*', 
    '.+'
  )

select 
  post_poll_options.*, 
  (
    select 
      concat(
        a.display_name, '  ', a.level, '  ', 
        a.user_name
      ) 
    from 
      account a 
    where 
      a.id_account = post_poll_options.added_by
  ) as _user_data, 
  (
    select 
      count(v.voted_option) 
    from 
      post_poll_votes v 
    where 
      v.id_post = post_poll_options.id_post 
      and v.voted_option = post_poll_options.id_option
  ) as votes 
from 
  post_poll_options 
where 
  id_post = '5011501975510017' 
order by 
  id_option asc

select 
  count(*) as total_rows 
from 
  posts 
where 
  status = 'published' 
  and visibility <> 'private' 
  and publishing_date <= '2017-08-17 22:11:56' 
  and (
    expiration_date = '0000-00-00 00:00:00' 
    or expiration_date > '2017-08-17 22:11:56'
  ) 
  and visibility = 'public' 
  and (
    posts.main_category in (
      select 
        id_category 
      from 
        categories 
      where 
        visibility = 'public' 
        or visibility = 'users' 
        or (
          visibility = 'level_based' 
          and '1' >= min_level
        )
    )
  ) 
  and id_post not in (
    select 
      post_tags.id_post 
    from 
      post_tags 
    where 
      post_tags.id_post = posts.id_post 
      and post_tags.tag = ''
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'forums'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'cryptocurrencies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'bitcoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'dogecoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'litecoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'family-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'horror-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'sci-fi-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'bmw-cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'audi-cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'ford-cars-forum'
  )

select 
  posts.id_post, 
  posts.parent_post, 
  posts.id_author, 
  posts.slug, 
  posts.title, 
  posts.excerpt, 
  posts.content, 
  posts.main_category, 
  posts.visibility, 
  posts.status, 
  posts.password, 
  posts.allow_comments, 
  posts.pin_to_home, 
  posts.pin_to_main_category_index, 
  posts.creation_date, 
  posts.creation_ip, 
  posts.creation_host, 
  posts.creation_location, 
  posts.publishing_date, 
  posts.expiration_date, 
  posts.comments_count, 
  posts.last_update, 
  posts.id_featured_image, 
  (
    select 
      views 
    from 
      post_views 
    where 
      post_views.id_post = posts.id_post
  ) as views, 
  (
    select 
      last_viewed 
    from 
      post_views 
    where 
      post_views.id_post = posts.id_post
  ) as last_viewed, 
  (
    select 
      concat(
        user_name, '\t', display_name, '\t', 
        email, '\t', level
      ) 
    from 
      account 
    where 
      account.id_account = posts.id_author
  ) as _author_data, 
  (
    select 
      concat(
        slug, '\t', title, '\t', visibility, 
        '\t', min_level
      ) 
    from 
      categories 
    where 
      categories.id_category = posts.main_category
  ) as _main_category_data, 
  (
    select 
      path 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_image_path, 
  (
    select 
      thumbnail 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_image_thumbnail, 
  (
    select 
      type 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_media_type, 
  (
    select 
      group_concat(
        tag 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_tags 
    where 
      post_tags.id_post = posts.id_post
  ) as tags_list, 
  (
    select 
      group_concat(
        id_media 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_media 
    where 
      post_media.id_post = posts.id_post
  ) as media_list, 
  (
    select 
      group_concat(
        id_category 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_categories 
    where 
      post_categories.id_post = posts.id_post
  ) as categories_list, 
  (
    select 
      group_concat(
        id_account 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_mentions 
    where 
      post_mentions.id_post = posts.id_post
  ) as mentions_list, 
  (
    select 
      title 
    from 
      posts p2 
    where 
      p2.id_post = posts.parent_post
  ) as parent_post_title, 
  (
    select 
      slug 
    from 
      posts p2 
    where 
      p2.id_post = posts.parent_post
  ) as parent_post_slug, 
  (
    select 
      count(id_post) 
    from 
      posts p2 
    where 
      p2.parent_post = posts.id_post
  ) as children_count, 
  (
    select 
      c.creation_date 
    from 
      comments c 
    where 
      c.id_post = posts.id_post 
      and c.status = 'published' 
    order by 
      c.creation_date desc 
    limit 
      1
  ) as last_commented 
from 
  `posts` 
where 
  status = 'published' 
  and visibility <> 'private' 
  and publishing_date <= '2017-08-17 22:11:56' 
  and (
    expiration_date = '0000-00-00 00:00:00' 
    or expiration_date > '2017-08-17 22:11:56'
  ) 
  and visibility = 'public' 
  and (
    posts.main_category in (
      select 
        id_category 
      from 
        categories 
      where 
        visibility = 'public' 
        or visibility = 'users' 
        or (
          visibility = 'level_based' 
          and '1' >= min_level
        )
    )
  ) 
  and id_post not in (
    select 
      post_tags.id_post 
    from 
      post_tags 
    where 
      post_tags.id_post = posts.id_post 
      and post_tags.tag = ''
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'forums'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'cryptocurrencies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'bitcoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'dogecoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'litecoin-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'family-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'horror-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'sci-fi-movies-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'bmw-cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'audi-cars-forum'
  ) 
  and main_category not in (
    select 
      id_category 
    from 
      categories 
    where 
      slug = 'ford-cars-forum'
  ) 
order by 
  pin_to_home desc, 
  publishing_date desc 
limit 
  30 offset 0

select 
  * 
from 
  `account` 
where 
  id_account in ('100000000000000')

(
  select 
    * 
  from 
    comments 
  where 
    status = 'published' 
    and id_post = '5011501975510017' 
  order by 
    creation_date desc 
  limit 
    10
) 
union 
  (
    select 
      * 
    from 
      comments 
    where 
      status = 'published' 
      and id_post = '5011499350846715' 
    order by 
      creation_date desc 
    limit 
      10
  ) 
union 
  (
    select 
      * 
    from 
      comments 
    where 
      status = 'published' 
      and id_post = '5011499350565001' 
    order by 
      creation_date desc 
    limit 
      10
  ) 
union 
  (
    select 
      * 
    from 
      comments 
    where 
      status = 'published' 
      and id_post = '5011490054242058' 
    order by 
      creation_date desc 
    limit 
      10
  ) 
union 
  (
    select 
      * 
    from 
      comments 
    where 
      status = 'published' 
      and id_post = '5011490055007816' 
    order by 
      creation_date desc 
    limit 
      10
  )

select 
  posts.id_post, 
  posts.parent_post, 
  posts.id_author, 
  posts.slug, 
  posts.title, 
  posts.excerpt, 
  posts.content, 
  posts.main_category, 
  posts.visibility, 
  posts.status, 
  posts.password, 
  posts.allow_comments, 
  posts.pin_to_home, 
  posts.pin_to_main_category_index, 
  posts.creation_date, 
  posts.creation_ip, 
  posts.creation_host, 
  posts.creation_location, 
  posts.publishing_date, 
  posts.expiration_date, 
  posts.comments_count, 
  posts.last_update, 
  posts.id_featured_image, 
  (
    select 
      views 
    from 
      post_views 
    where 
      post_views.id_post = posts.id_post
  ) as views, 
  (
    select 
      last_viewed 
    from 
      post_views 
    where 
      post_views.id_post = posts.id_post
  ) as last_viewed, 
  (
    select 
      concat(
        user_name, '\t', display_name, '\t', 
        email, '\t', level
      ) 
    from 
      account 
    where 
      account.id_account = posts.id_author
  ) as _author_data, 
  (
    select 
      concat(
        slug, '\t', title, '\t', visibility, 
        '\t', min_level
      ) 
    from 
      categories 
    where 
      categories.id_category = posts.main_category
  ) as _main_category_data, 
  (
    select 
      path 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_image_path, 
  (
    select 
      thumbnail 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_image_thumbnail, 
  (
    select 
      type 
    from 
      media 
    where 
      media.id_media = posts.id_featured_image
  ) as featured_media_type, 
  (
    select 
      group_concat(
        tag 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_tags 
    where 
      post_tags.id_post = posts.id_post
  ) as tags_list, 
  (
    select 
      group_concat(
        id_media 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_media 
    where 
      post_media.id_post = posts.id_post
  ) as media_list, 
  (
    select 
      group_concat(
        id_category 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_categories 
    where 
      post_categories.id_post = posts.id_post
  ) as categories_list, 
  (
    select 
      group_concat(
        id_account 
        order by 
          date_attached asc, 
          order_attached asc separator ','
      ) 
    from 
      post_mentions 
    where 
      post_mentions.id_post = posts.id_post
  ) as mentions_list, 
  (
    select 
      title 
    from 
      posts p2 
    where 
      p2.id_post = posts.parent_post
  ) as parent_post_title, 
  (
    select 
      slug 
    from 
      posts p2 
    where 
      p2.id_post = posts.parent_post
  ) as parent_post_slug, 
  (
    select 
      count(id_post) 
    from 
      posts p2 
    where 
      p2.parent_post = posts.id_post
  ) as children_count, 
  (
    select 
      c.creation_date 
    from 
      comments c 
    where 
      c.id_post = posts.id_post 
      and c.status = 'published' 
    order by 
      c.creation_date desc 
    limit 
      1
  ) as last_commented 
from 
  `posts` 
where 
  status = 'published' 
  and visibility <> 'private' 
  and publishing_date <= '2017-08-17 22:11:56' 
  and (
    expiration_date = '0000-00-00 00:00:00' 
    or expiration_date > '2017-08-17 22:11:56'
  ) 
  and visibility = 'public' 
  and (
    posts.main_category in (
      select 
        id_category 
      from 
        categories 
      where 
        visibility = 'public' 
        or visibility = 'users' 
        or (
          visibility = 'level_based' 
          and '1' >= min_level
        )
    )
  ) 
  and id_post in (
    select 
      post_tags.id_post 
    from 
      post_tags 
    where 
      post_tags.id_post = posts.id_post 
      and post_tags.tag = ''
  ) 
order by 
  pin_to_home desc, 
  publishing_date desc