#HTTP
if ($uri !~* ^/downloads/(.+)$) {
return 301 http://example.com/downloads/$1;
}
#HTTPS
rewrite ^/downloads/(.+)$ http://example.com/downloads/$1 permanent;<li <?= false !== strpos($_SERVER['REQUEST_URI'], '/') ? 'class="active"' : '' ?> ><li <?= false !== strpos($_SERVER['REQUEST_URI'], '/index.php') ? 'class="active"' : '' ?> >SELECT a.id as id, a.added_date, a.updated_date, a.codename, a.title, a.tech_title, group_concat(c.name) as category, f.name as family, d.name as developer, a.os, a.domain, a.FULL_URL, a.publicly_called, a.has_image, a.Available_for_PPC, a.PPC_Risk, a.Is_in_blogs, a.Publish_in_Blog, a.Publish_in_Feed, a.IS_IN_SOFT, a.Has_Tech_Info, u.nick as assigned_to, s.name as status, a.domain_popularity, a.adwords_activity, a.lp, a.seo, a.partners, a.Software_Scan, a.Software_Fix, a.tickets, a.Youtube_URL, a.SEVERITY, a.Image_URL
FROM artpost_table as a
LEFT JOIN developer as d on a.developer = d.id
LEFT JOIN family as f on a.family = f.id
LEFT JOIN users as u on a.assigned_to = u.id
LEFT JOIN status as s on a.status = s.id
LEFT JOIN category c on find_in_set(c.id, a.category)>0
group by a.id
SELECT a.id as id, a.added_date, a.updated_date, a.codename, a.title, a.tech_title, c.name as category, f.name as family, d.name as developer, a.os, a.domain, a.FULL_URL, a.publicly_called, a.has_image, a.Available_for_PPC, a.PPC_Risk, a.Is_in_blogs, a.Publish_in_Blog, a.Publish_in_Feed, a.IS_IN_SOFT, a.Has_Tech_Info, u.nick as assigned_to, s.name as status, a.domain_popularity, a.adwords_activity, a.lp, a.seo, a.partners, a.Software_Scan, a.Software_Fix, a.tickets, a.Youtube_URL, a.SEVERITY, a.Image_URL
FROM artpost_table as a
LEFT JOIN developer as d on a.developer = d.id
LEFT JOIN family as f on a.family = f.id
LEFT JOIN users as u on a.assigned_to = u.id
LEFT JOIN status as s on a.status = s.id
left join category as c on a.category = c.id