select `media_confs`.`mediaurl`, `media_confs`.`mediatype`, `media_confs`.`altattr`, `media_confs`.`updated_at` as `media_updated_at` from `media_confs` where `mediafor` ='aboutus-banner'and `is_active` =1
select `media_confs`.`mediaurl`, `media_confs`.`mediatype`, `media_confs`.`altattr`, `media_confs`.`updated_at` as `media_updated_at` from `media_confs` where `mediafor` ='preview-desktop'and `is_active` =1
select `media_confs`.`mediaurl`, `media_confs`.`mediatype`, `media_confs`.`altattr`, `media_confs`.`updated_at` as `media_updated_at` from `media_confs` where `mediafor` ='preview-square'and `is_active` =1
select `blog_posts`.`title`, `blog_posts`.`slug`, `blog_posts`.`id`, `mc`.`mediaurl`, `mc`.`mediatype`, `mc`.`updated_at` as `media_updated_at`, `mc`.`altattr` from `blog_posts` innerjoin `media_confs` as `mc` on `mc`.`linkedid` = `blog_posts`.`id` innerjoin `attr_region_maps` as `arm` on `blog_posts`.`id` = `arm`.`attr_id` innerjoin `attr_types` as `at` on `at`.`id` = `arm`.`attr_type_id` innerjoin `regions` as `rg` on `rg`.`id` = `arm`.`region_id` where `mc`.`mediafor` ='blogs'and `rg`.`name` ='in'and `at`.`attr_type` ='blogs'and `blog_posts`.`is_active` =1orderby `blog_posts`.`updated_at` desc