Cafés

user warning: Expression #5 of SELECT list is not in GROUP BY clause and contains nonaggregated column 's061626d_drupal.term_data.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by query: SELECT COUNT(*) FROM (SELECT DISTINCT(node.nid) AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, term_data.name AS term_data_name, term_data.vid AS term_data_vid, term_data.tid AS term_data_tid, node_revisions.body AS node_revisions_body, node_revisions.format AS node_revisions_format, uc_products.sell_price AS uc_products_sell_price, uc_products.model AS uc_products_model FROM node node LEFT JOIN term_node term_node ON node.vid = term_node.vid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (node.type in ('product')) AND (node.vid IN ( SELECT tn.vid FROM term_node tn LEFT JOIN term_hierarchy th ON th.tid = tn.tid LEFT JOIN term_hierarchy th1 ON th.parent = th1.tid WHERE tn.tid = 9 OR th1.tid = 9 )) GROUP BY nid ORDER BY node_title ASC ) count_alias in /home/s061626d/public_html/sites/all/modules/views/includes/view.inc on line 805.
Blend Desayuno
Nuestros blends
De intenso sabor y aroma frutal, ideal para el desayuno. *Taza no incl...
3,20€
1019
Brasil - Cerrado
Arábica
Destaca especialmente su sabor algo dulzón y persistente. Caf...
3,00€
1007
Café Bajo en Cafeína
Nuestros blends
Destaca su sabor amargo y con mucho cuerpo. *Taza no incluida
3,20€
1022
Capsulas Sol & Crema
Cápsulas
Cajas de 100 capsulas de 7 gramos cada una (Cápsulas compatible...
34,40€
0057
Colombia Supremo
Arábica
Posee un pronunciado aroma y un sabor que recuerda a frutas y flores c...
3,00€
1001
Costa Rica - Tarruza
Arábica
Café suave, con cuerpo, de alta acidez y muy rico en aroma. Los...
3,15€
1004
Descafeinado Natural Grano/Molido
Descafeinados
3,20€
1028
Descafeinado soluble en bolsita Cafés Sol & Crema
Descafeinados
Estuches con 100 sobres, de 2 gramos cada uno.
8,95€
0008
Mezcla de la Casa
Nuestros blends
“Blend” exclusivo de Cafés de  la variedad Ar...
3,00€
1013
Selección Alacena de Carlos Herrera
Nuestros blends
Seleccionado cuidadosamente a la tienda Gourmet para la alacena de Car...
3,50€
1025
 
Ctra de Almería, 34 - 18600 Motril (Granada)
Tfnos: 958 60 34 96 Fax: 958 83 49 17
email:contacto@cafessolycrema.com
Cafes Sol&Crema 2010®
 
Web realizada en Motril por: ICC