1 | SELECT `SeoStatusCode`.`status_code`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_status_codes` AS `SeoStatusCode` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoStatusCode`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoStatusCode`.`is_active` = '1' AND `SeoUri`.`is_approved` = '1' ORDER BY `SeoStatusCode`.`priority` ASC | | 0 | 0 | 1 |
2 | SELECT `SeoRedirect`.`redirect`, `SeoRedirect`.`id`, `SeoRedirect`.`callback`, `SeoRedirect`.`is_nocache`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_redirects` AS `SeoRedirect` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoRedirect`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoRedirect`.`is_active` = '1' AND `SeoUri`.`is_approved` = '1' ORDER BY `SeoRedirect`.`priority` ASC | | 0 | 0 | 0 |
3 | SELECT `SeoTitle`.`title`, `SeoUri`.`uri`, `SeoUri`.`id` FROM `inviasa_inv`.`seo_titles` AS `SeoTitle` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoTitle`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/roundcube' AND `SeoUri`.`is_approved` = '1' LIMIT 1 | | 0 | 0 | 1 |
4 | SELECT `SeoMetaTag`.`id`, `SeoMetaTag`.`seo_uri_id`, `SeoMetaTag`.`name`, `SeoMetaTag`.`content`, `SeoMetaTag`.`is_http_equiv`, `SeoMetaTag`.`created`, `SeoMetaTag`.`modified`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_meta_tags` AS `SeoMetaTag` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoMetaTag`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/roundcube' AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 1 |
5 | SELECT `SeoUri`.`id`, `SeoUri`.`uri` FROM `inviasa_inv`.`seo_uris` AS `SeoUri` WHERE ((`SeoUri`.`uri` LIKE '#%') OR (`SeoUri`.`uri` LIKE '%*')) AND `SeoUri`.`is_approved` = '1' | | 0 | 0 | 0 |
6 | SELECT `SeoCanonical`.`canonical` FROM `inviasa_inv`.`seo_canonicals` AS `SeoCanonical` LEFT JOIN `inviasa_inv`.`seo_uris` AS `SeoUri` ON (`SeoCanonical`.`seo_uri_id` = `SeoUri`.`id`) WHERE `SeoUri`.`uri` = '/roundcube' AND `SeoUri`.`is_approved` = '1' AND `SeoCanonical`.`is_active` = '1' LIMIT 1 | | 0 | 0 | 0 |