Kioscos digitales, impresoras y equipos profesionales on-line.  

kioskoFoto presenta sus kioskocos digitales, impresoras profesionales y equipos fotográficos, con un extenso y variado catálogo, a través de su tienda virtual.  

Con una amplia experiencia en la venta de kioskocos digitales e impresoras profesionales, en kioskoFoto nos hemos especializado en venta de kioscos digitales e impresoras profesionales para facilitar a nuestros clientes un servicio personalizado, con el objetivo de ofrecerles el producto que mejor se adapte a sus necesidades.

La solución más recomendada para fotoacabado digital y fotocarnet de sobremesa

 Sony Snap Lab Digital Photo Printer UP-CR10LSony Snap Lab Digital Photo Printer UP-CR10LSony Snap Lab Digital Photo Printer UP-CR10LSony Snap Lab Digital Photo Printer UP-CR10LSony Snap Lab Digital Photo Printer UP-CR10L

La impresora Sony Snap Lab Digital Photo Printer UP-CR10L cuenta con un diseño elegante y compacto. Pantalla tácil LCD de 8" a color. Impresora pequeña y ligera. Copias de 9x13, 10x15 y 13x18 cm en segundos mediante tecnología de sublimación de tinta de Sony. Rápida puesta en marcha, alta velocidad y alta calidad. Funciones de edición fotográfica y gestión de pedidos.

 

Soluciones flexibles y rentables  

Kioscos digitales Kodak GS/G4. Pequeños en tamaño, grandes en prestaciones. Existe un kiosco Kodak diseñado para ajustarse a las necesidades de su negocio.

Kioscos digitales Kodak Picture Kiosk GS/G4 

 

El kiosco Kodak más compacto

Kiosco digital Kodak GS compact. La nueva gama de Kodak en kioscos digitales para entrar el negocio de impresión digital al instante. Diseño compacto y muy fácil de instalar.

Kiosco digital Kodak Picture Kiosk GS Compact

  • Auténtico Plug&Play. Auto-instalable
  • Consumible 10x15/13x18/15x20 incluido 
  • Fácil de utilizar. Como un cajero automático
  • Acepta todas las tarjetas estándar del mercado
  • Función foto carné con ajuste de guías por país
 
SOY609923 Sony Video Print Kit 2UPC-C15 (13x18)
€199,00 comprar
SOY609922 Sony Video Print Kit 2UPC-C14 (10x15)
€99,00 comprar
SOY800000 Sony Snap Lab Digital Photo Printer UP-CR10L
€1.290,00 comprar
SOY609906 Sony Photo Print Kit UPD-740 (A4)
€139,00 comprar
SOY609916 Sony Photo Print Kit 2UPC-R156 (15x20)
€249,00 comprar
KOD550013 Kodak Kit 120 Tarjetas Prepago 5 Euros
€129,00 comprar
DLY440010 Delsey Trolley Equipo Fotográfico PRO 50
€219,00 comprar
DLY440094.5 Delsey Bolso Cámara Réflex ODC 41
€39,00 comprar

Mi cuenta
Mi compra

¡Todavía no has comprado nada!

Laboratorios apex Kioscos digitales Consumibles kioscos Impresoras fotográficas Consumibles impresoras Equipos foto carnet Consumibles foto carnet Cámaras réflex Cámaras compactas Visores multimedia Marcos digitales Bolsos cámaras réflex Bolsos equipos fotográficos Mochilas equipos fotográficos Trolleys equipos fotográficos

Ver todos los productos
 
 

 
 
186 queries executed
1
SET sql_mode = 'MYSQL40'
2 SELECT folder, element, published, params FROM jos_mambots WHERE published >= 1 AND access <= 0 AND folder = 'system' ORDER BY ordering
3 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
4 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 1 ) ORDER BY menuid DESC LIMIT 1
5 DELETE FROM jos_session WHERE ( ( time < '1418980158' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1418980158' ) AND guest = 1 AND userid = 0 )
6 SELECT * FROM jos_menu WHERE id = 1
7 SELECT COUNT(a.id) FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-12-19 10:24' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-12-19 10:24' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0
8 SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits, CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups , s.id AS sec_id, cc.id as cat_id FROM jos_content AS a INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid LEFT JOIN jos_users AS u ON u.id = a.created_by LEFT JOIN jos_groups AS g ON a.access = g.id WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-12-19 10:24' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-12-19 10:24' ) AND s.published = 1 AND cc.published = 1 AND a.access <= 0 AND s.access <= 0 AND cc.access <= 0 ORDER BY a.created DESC LIMIT 4
9 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
10 SELECT params FROM jos_mambots WHERE element = 'mosimage' AND folder = 'content'
11 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` >= '0')) ORDER BY parent, ordering
12 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=37'
13 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=29&lang=es&task=view'
14 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=30&lang=es&task=view'
15 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=31&lang=es&task=view'
16 SELECT sectionid from jos_content WHERE id = 31
17 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
18 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=31'
19 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 31 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
20 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
21 SELECT id FROM jos_menu WHERE type = 'content_blog_category' AND published = 1 AND componentid = 0
22 SELECT a.title AS title FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=31
23 SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=1&id=31&lang=es&task=view'
24 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=32&lang=es&task=view'
25 SELECT sectionid from jos_content WHERE id = 32
26 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=32'
27 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 32 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28 SELECT a.title AS title FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=32
29 SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=1&id=32&lang=es&task=view'
30 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=33&lang=es&task=view'
31 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=34&lang=es&task=view'
32 SELECT sectionid from jos_content WHERE id = 34
33 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=34'
34 SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid = s.id LEFT JOIN jos_menu AS ms ON ms.componentid = s.id LEFT JOIN jos_categories AS c ON i.catid = c.id LEFT JOIN jos_menu AS mc ON mc.componentid = c.id WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) ) AND i.id = 34 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35 SELECT a.title AS title FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=34
36 SELECT oldurl from jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=1&id=34&lang=es&task=view'
37 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=15&lang=es&task=view'
38 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&id=35&lang=es&task=view'
39 SELECT a.* FROM jos_components AS a WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' ) AND a.option = 'com_syndicate'
40 SELECT id, title, module, position, content, showtitle, params FROM jos_modules AS m INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 0 AND m.client_id != 1 AND ( mm.menuid = 0 OR mm.menuid = 1 ) ORDER BY ordering
41 SELECT m.* FROM jos_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
42 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid=3&lang=es'
43 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=21'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=27&id=21&lang=es&task=view'
45 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
46 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=28&id=16&lang=es&task=view'
47 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=17'
48 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=29&id=17&lang=es&task=view'
49 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=38&lang=es&page=price.product_list'
50 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=18'
51 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=30&id=18&lang=es&task=view'
52 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=24'
53 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=35&id=24&lang=es&task=view'
54 SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping, vendor_address_1, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code, vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,contact_fax,vendor_url FROM (`jos_vm_vendor`, `jos_vm_country`) WHERE `vendor_id`=1 AND (vendor_country=country_2_code OR vendor_country=country_3_code);
55 SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount FROM `jos_vm_shopper_group` WHERE jos_vm_shopper_group.vendor_id='1' AND `default`='1'
56 SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
57 SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
58 SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 3 AND 12 GROUP BY g1.name ORDER BY g1.lft
59 SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
60 SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM jos_core_acl_aro_groups AS g1 INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt WHERE g1.lft BETWEEN 13 AND 20 GROUP BY g1.name ORDER BY g1.lft
61 SELECT DISTINCT product_sku FROM jos_vm_product WHERE product_parent_id='' AND vendor_id='1' AND jos_vm_product.product_publish='Y' AND jos_vm_product.product_special='N' ORDER BY product_name DESC
62 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SOY609923'
63 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='39' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
64 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='39'
65 SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
66 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=2&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=39'
67 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='39'
68 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='39' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
69 SELECT vendor_id FROM jos_vm_product WHERE product_id='39'
70 SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
71 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
72 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
73 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='39'
74 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='39' AND shopper_group_id='5' ORDER BY price_quantity_start
75 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='39'
76 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=39'
77 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SOY609922'
78 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='40' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
79 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='40'
80 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=2&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=40'
81 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='40'
82 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='40' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
83 SELECT vendor_id FROM jos_vm_product WHERE product_id='40'
84 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='40'
85 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='40' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
86 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='40'
87 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='40' AND shopper_group_id='5' ORDER BY price_quantity_start
88 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='40'
89 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=40'
90 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SOY800000'
91 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='37' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
92 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='37'
93 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=1&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=37'
94 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='37'
95 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='37' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
96 SELECT vendor_id FROM jos_vm_product WHERE product_id='37'
97 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='37'
98 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
99 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='37'
100 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='37' AND shopper_group_id='5' ORDER BY price_quantity_start
101 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='37'
102 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=37'
103 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SOY609906'
104 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='42' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
105 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='42'
106 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=5&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=42'
107 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='42'
108 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='42' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
109 SELECT vendor_id FROM jos_vm_product WHERE product_id='42'
110 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='42'
111 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='42' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
112 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='42'
113 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='42' AND shopper_group_id='5' ORDER BY price_quantity_start
114 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='42'
115 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=42'
116 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='SOY609916'
117 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='46' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
118 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='46'
119 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=5&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=46'
120 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='46'
121 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='46' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
122 SELECT vendor_id FROM jos_vm_product WHERE product_id='46'
123 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
124 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
125 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='46'
126 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='46' AND shopper_group_id='5' ORDER BY price_quantity_start
127 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='46'
128 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=46'
129 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='KOD550013'
130 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='28' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
131 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='28'
132 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=2&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=28'
133 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='28'
134 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='28' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
135 SELECT vendor_id FROM jos_vm_product WHERE product_id='28'
136 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
137 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
138 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='28'
139 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='28' AND shopper_group_id='5' ORDER BY price_quantity_start
140 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='28'
141 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=28'
142 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='DLY440010'
143 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='80' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
144 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='80'
145 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=23&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=80'
146 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='80'
147 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='80' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
148 SELECT vendor_id FROM jos_vm_product WHERE product_id='80'
149 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='80'
150 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='80' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
151 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='80'
152 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='80' AND shopper_group_id='5' ORDER BY price_quantity_start
153 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='80'
154 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=80'
155 SELECT product_id, product_sku, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='DLY440094.5'
156 SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='62' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
157 SELECT `jos_vm_product`.`product_parent_id` AS product_parent_id, `jos_vm_category`.`category_flypage` FROM `jos_vm_product` LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id` LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id` WHERE `jos_vm_product`.`product_id`='62'
158 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=15&flypage=shop.Detalle-producto&lang=es&page=shop.product_details&product_id=62'
159 SELECT product_id, `product_name` FROM jos_vm_product WHERE product_id='62'
160 SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='62' AND (start_date<='1418981058' OR start_date=0) AND (end_date>='1418942160' OR end_date=0) AND product_discount_id=discount_id
161 SELECT vendor_id FROM jos_vm_product WHERE product_id='62'
162 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='62'
163 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='62' AND shopper_group_id='5' AND (('0' >= price_quantity_start AND '0' <= price_quantity_end) OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
164 SELECT product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='62'
165 SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='62' AND shopper_group_id='5' ORDER BY price_quantity_start
166 SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='62'
167 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&func=cartAdd&lang=es&page=shop.cart&product_id=62'
168 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=es&page=shop.registration'
169 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=es&page=shop.cart'
170 SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
171 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=24&lang=es&page=shop.browse'
172 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=1&lang=es&page=shop.browse'
173 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=2&lang=es&page=shop.browse'
174 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=3&lang=es&page=shop.browse'
175 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=5&lang=es&page=shop.browse'
176 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=14&lang=es&page=shop.browse'
177 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=21&lang=es&page=shop.browse'
178 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=20&lang=es&page=shop.browse'
179 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=12&lang=es&page=shop.browse'
180 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=17&lang=es&page=shop.browse'
181 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=18&lang=es&page=shop.browse'
182 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=15&lang=es&page=shop.browse'
183 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=16&lang=es&page=shop.browse'
184 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=22&lang=es&page=shop.browse'
185 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&category_id=23&lang=es&page=shop.browse'
186 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_virtuemart&Itemid=1&lang=es&page=shop.browse'