CALENDARIO IMAGINE DRAGONS
section
post
posts
url_post
slug_category
obLevel
__env
app
errors
settings
theme
path
exchanges
brands
one2events
contentCategories
cruceros
eventos
select * from `settings` where `status` = 'activo'
SELECT *
select * from `currencies` where `status` = 'activo'
select * from `brands` where `status` = 'activo' and `slug` <> 'one2events'
select * from `brands` where `status` = 'activo' and `slug` = 'one2events' limit 1
LIMIT
ORDER BY
select * from `blog_categories` where `status` = 'activo' and `slug` = 'conciertos' or `slug` = 'one2events' order by `name` asc
select * from `blog_categories` where `slug` like '%crucero%' and `status` = 'activo' order by `name` asc
select * from `blog_categories` where `slug` not in ('one2mexico', 'one2events', 'noticias', 'conciertos', 'cruceros') and `status` = 'activo' order by `name` asc
select * from `posts_translations` where `slug` = 'conciertos-imagine-dragons' and `locale` = 'es' limit 1
select * from `blog_categories` where `slug` = 'conciertos' limit 1
select * from `posts` left join `posts_translations` on `posts`.`id` = `posts_translations`.`id` where `posts`.`status` = 'publicado' and `posts`.`category_id` = '7' and `posts`.`id` <> '159' order by RAND() limit 6
ORDER BY RAND()
select * from `posts` where `posts`.`id` = '159' limit 1
select * from `posts_translations` where `posts_translations`.`post_id` = '157' and `posts_translations`.`post_id` is not null