SELECT categories_campaigns.image, start_date, end_date, campaigns.name
FROM categories_campaigns
LEFT JOIN campaigns ON categories_campaigns.campaign_id = campaigns.id
LEFT JOIN sites ON sites.id = categories_campaigns.site_id
WHERE categories_campaigns.category_id =1
AND (
categories_campaigns.start_date <= NOW( )
AND categories_campaigns.end_date >= NOW( )
)
AND sites.title = 'portugal'
ORDER BY campaigns.name
LIMIT 0 , 30