SELECT * FROM publicidade WHERE posicao = 'super-banner' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'super-banner' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 3
Mais Vendidos do mês
Os mais vendidos do mês com o preço que você procura.
SELECT * FROM publicidade WHERE posicao = 'banner-meio' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'banner-meio' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 1
SELECT * FROM publicidade WHERE posicao = 'super-banner-fixo' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'super-banner-fixo' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 1
SELECT * FROM publicidade WHERE posicao = 'sub-banner-fixo' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'sub-banner-fixo' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 1
SELECT * FROM publicidade WHERE posicao = 'banner-meio-mobile' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'banner-meio-mobile' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 1
SELECT * FROM publicidade WHERE posicao = 'banner-categoria-triplo' AND status = '1' AND dataini = '0000-00-00 00:00:00' OR posicao = 'banner-categoria-triplo' AND status = '1' AND CURDATE() between dataini and datafin ORDER BY ordem ASC LIMIT 3