Error
  • Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM umhys_content AS a LEFT JOIN umhys_categories AS c ON c.id = a.catid LEFT JOIN umhys_users AS ua ON ua.id = a.created_by LEFT JOIN umhys_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM umhys_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN umhys_categories as parent ON parent.id = c.parent_id LEFT JOIN umhys_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM umhys_categories AS cat JOIN umhys_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN umhys_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-26 01:53:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-26 01:53:29') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 4 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM umhys_content AS a LEFT JOIN umhys_categories AS c ON c.id = a.catid LEFT JOIN umhys_users AS ua ON ua.id = a.created_by LEFT JOIN umhys_users AS uam ON uam.id = a.modified_by LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM umhys_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN umhys_categories as parent ON parent.id = c.parent_id LEFT JOIN umhys_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM umhys_categories AS cat JOIN umhys_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN umhys_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-26 01:53:29') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-26 01:53:29') GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls ORDER BY c.lft, fp.ordering, a.created DESC
  • Crecimos en forma continua para brindar un servicio de excelencia Honramos la confianza que nuestros clientes y sus afiliados depositan en nosotros.
  • El liderazgo de nuestra empresa es el resultado de acciones éticas y transparentes Líderes en la venta y distribución de medicamentos para Terapias Especiales,a través de una gestión sustentable y un compromiso innovador en los servicios de la salud.
  • Garantizamos la máxima seguridad de los medicamentos Pioneros en la implementación de un sistema de trazabilidad que asegura la procedencia y la calidad de los medicamentos entregados.
  • Ofrecemos servicios que señalan un camino a seguir en el sector de la salud Scienza Argentina es una empresa de servicios que ha buscado y logrado ocupar un lugar clave en el sector farmacéutico.
VIDEO

VIDEO INSTITUCIONAL “COMPROMETIDOS CON LA GENTE”

El video de Scienza Argentina que muestra el espíritu de la empresa y su misión en este país.

SCIENZA INCORPORA LA APLICACION INFORMATICA SAP

Una herramienta que utilizan las compañías de primera línea. Un salto tecnológico para seguir creciendo aún más.Una renovación tecnológica que reemplazará por completo al actual sistema Armada, y que permitirá soportar los procesos de negocio de la compañía, acompañando el incremento en los volúmenes operados.

IMPLEMENTACION DATAMATRIX

Hemos implementado el código DATAMATRIX a nuestro sistema de trazabilidad.Esta evolución tecnológica es la más usada en el mercado farmacéutico y en la que confían los laboratorios nacionales e internacionales.

INFO

CANCER DE CUELLO UTERINO PREVENCION

Por año, mueren 1800 mujeres por Cáncer de Cuello Uterino en el país. 17 de cada 100.000 mujeres son diagnosticadas con este tipo de cáncer.

Un centro de atención desarrollado para brindar
respuesta a todas sus consultas.

COMUNICATE CON NOSOTROS
0810-222-SCIENZA (7243)

Scienza Responde
  1. NOMBRE(*)
    Nombre inválido!
  2. APELLIDO
    Apellido inválido!
  3. PREPAGA/O.S.
    Invalid Input
  4. MAIL
    Mail inválido!
  5. TELEFONO
    Teléfono inválido!
  6. Déjenos aquí su consulta o comentario para que podamos ayudarlo.
    Invalid Input

LINEAS DIRECTAS DE VENTA

11-4126-7900 / 11-5554-7900