Conheça nossas Mídias Sociais

http://www.twitter.com/bordado_ingles

http://www.facebook.com/pages/Bordado-Ingles/144351075613438

http://camamesabanho.wordpress.com/.

Venha fazer a sua Lista de Casamento no Bordado Inglês
Busca Avançada
Resultados 1 para 1 (de 1 produtos) - Resultado de páginas:  1 
1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'admin_bordado.p.products_image' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

select distinct p.products_image, p.products_quantity, p.products_status, m.manufacturers_id, p.products_id, p.imagem_produto_1, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id, products_description pd, categories c, categories_description cd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and cd.categories_id = c.categories_id AND(pd.products_name like '%toalha%' or p.products_model like '%toalha%' or m.manufacturers_name like '%toalha%' or cd.categories_name LIKE '%toalha%' OR REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(lcase(CONVERT(pd.products_name using latin1)),'-',' '),';',' '),'í','I'),'ä','A'),'ë','E'),'ü','U'),'é','E'),'á','A'),'ú','U'),'ã','A'),'õ','O'),'ê','E'),'ô','O'),'ç','C') LIKE '%TOALHA%' OR REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(lcase(CONVERT(p.products_model using latin1)),'-',' '),';',' '),'í','I'),'ä','A'),'ë','E'),'ü','U'),'é','E'),'á','A'),'ú','U'),'ã','A'),'õ','O'),'ê','E'),'ô','O'),'ç','C') LIKE '%TOALHA%' OR REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(lcase(CONVERT(m.manufacturers_name using latin1)),'-',' '),';',' '),'í','I'),'ä','A'),'ë','E'),'ü','U'),'é','E'),'á','A'),'ú','U'),'ã','A'),'õ','O'),'ê','E'),'ô','O'),'ç','C') LIKE '%TOALHA%' OR REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(lcase(CONVERT(cd.categories_name using latin1)),'-',' '),';',' '),'í','I'),'ä','A'),'ë','E'),'ü','U'),'é','E'),'á','A'),'ú','U'),'ã','A'),'õ','O'),'ê','E'),'ô','O'),'ç','C') LIKE '%TOALHA%') group by pd.products_name order by pd.products_name limit 0, 10

[TEP STOP]