section
posts
experiences
next_events
obLevel
__env
app
errors
settings
theme
path
exchanges
brands
one2events
contentCategories
cruceros
eventos
experience
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` left join `posts_translations` on `posts`.`id` = `posts_translations`.`id` where `posts`.`status` = 'publicado' order by `posts_translations`.`created_at` desc
select `experiences`.`name`, `experiences`.`slug`, `experiences`.`category_id`, `experiences`.`main_banner`, `brands`.`slug` as `slug_brand` from `experiences` inner join `brands_categories` on `brands_categories`.`id` = `experiences`.`category_id` inner join `brands` on `brands`.`id` = `brands_categories`.`brand_id` where `experiences`.`status` = 'activo' and `experiences`.`expiration_date` > '2025-01-21 00:37:47' and `experiences`.`home` = '1' order by RAND() limit 4
ORDER BY RAND()
select * from `brands_categories` where `brands_categories`.`id` in ('7', '8')
select `experiences`.`name`, `experiences`.`slug`, `experiences`.`category_id`, `experiences`.`main_banner`, `brands`.`slug` as `slug_brand` from `experiences` inner join `brands_categories` on `brands_categories`.`id` = `experiences`.`category_id` inner join `brands` on `brands`.`id` = `brands_categories`.`brand_id` where `experiences`.`status` = 'activo' and `experiences`.`expiration_date` > '2025-01-21 00:37:47' and `experiences`.`expiration_date` < '2025-05-21 00:37:47' order by RAND(), `experiences`.`expiration_date` asc limit 4
select * from `brands_categories` where `brands_categories`.`id` in ('39', '112', '41')