1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>
MEN ON GIRDER new yorkNEW YORK taxi no.1

NEW YORK brooklyn bridge night

NEW YORK brooklyn bridge night
giant 100x140cm

 

Solicitar información





Actualmente el producto no está disponible.

Opiniones de los usuarios:

No hay opiniones para este producto.
Por favor, regístrese para escribir una opinión.

Categorías

Navegar productos

Moneda


Buscar Productos

Sede Galerías

 Calle 53B No. 23 - 27 - Barrio Galerías

Teléfono: (57-1) 346 2997 - 540 8439

Bogotá D.C.

Perfíl de la información

Application afterLoad: 0.002 seconds, 0.40 MB
Application afterInitialise: 0.041 seconds, 2.53 MB
Application afterRoute: 0.052 seconds, 3.49 MB
Application afterDispatch: 0.191 seconds, 10.06 MB
Application afterRender: 0.266 seconds, 11.53 MB

Memoria usada

12152960

87 queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = '24bruopjh9k52gnk2kmjngbth1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1716080692' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '24bruopjh9k52gnk2kmjngbth1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '24bruopjh9k52gnk2kmjngbth1','1716081292','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT `enabled`
      FROM `jos_components`
      WHERE `link` = "option=com_akeeba"
  8. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  13. SELECT g1.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
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  15. SELECT g1.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
  16. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, 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,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  17. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  18. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=107
      AND `product_publish`='Y'
  21. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='107'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  22. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='23'
      AND jos_vm_category.category_id='23'
  23. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='6'
      AND jos_vm_category.category_id='6'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
  27. 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`='89'
  28. 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`='86'
  29. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 588)
      ORDER BY menuid DESC
      LIMIT 0, 1
  30. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='23'
  31. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='107'
  32. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='107'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  33. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='107'
  34. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  36. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=107
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='107'
      AND (start_date<='1716081292' OR start_date=0)
      AND (end_date>='1716075360' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1716081292' OR start_date=0)
      AND (end_date>='1716075360' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=107
  41. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=1
      AND `file_published`=1
  43. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=0
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  48. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  49. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  51. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  52. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='107'
  53. SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='107'
      AND published='Y'
  54. SELECT comment, TIME, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='107'
      AND published='Y'
      ORDER BY `time` DESC  
      LIMIT 0, 5
  55. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='107'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  56. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='107'
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  58. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  59. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='107'
  60. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  61. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='107'
  62. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='107'
      AND product_publish='Y'
  63. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  64. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 588 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  65. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  66. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='6'
  67. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='6'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  68. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='24'
  69. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='25'
  70. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='8'
  71. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='9'
  72. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='10'
  73. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='11'
  74. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='12'
  75. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='13'
  76. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='14'
  77. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='15'
  78. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='16'
  79. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='17'
  80. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='22'
  81. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='23'
  82. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='26'
  83. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='18'
  84. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='19'
  85. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='20'
  86. SELECT a.category_child_id AS id,a.category_parent_id AS parent, b.category_name AS name
      FROM jos_vm_category_xref AS a, jos_vm_category AS b
      WHERE b.category_publish = 'Y'
      AND b.category_id = a.category_child_id
      ORDER BY b.list_order, b.category_name
  87. SELECT currency_id, currency_code, currency_name
      FROM `jos_vm_currency`
      WHERE FIND_IN_SET(`currency_code`, 'COP,USD,')
      ORDER BY `currency_name`

87 legado de las queries identificadas

  1. SELECT *
      FROM jos_session
      WHERE session_id = '24bruopjh9k52gnk2kmjngbth1'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1716080692' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '24bruopjh9k52gnk2kmjngbth1'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '24bruopjh9k52gnk2kmjngbth1','1716081292','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT `enabled`
      FROM `jos_components`
      WHERE `link` = "option=com_akeeba"
  8. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  9. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
  10. 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'
  11. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
  12. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
  13. SELECT g1.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
  14. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
  15. SELECT g1.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
  16. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1,vendor_address_2, vendor_url, 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,
                                            vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
                                   
      FROM (`jos_vm_vendor` v, `jos_vm_country` c)
                                   
      LEFT JOIN jos_vm_state s
      ON (v.vendor_state=s.state_2_code
      AND s.country_id=c.country_id)
                                   
      WHERE `v`.`vendor_id`=1
                                   
      AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
  17. SELECT module_id, module_name
      FROM jos_vm_module
      ORDER BY module_name
  18. SELECT module_perms
      FROM jos_vm_module
      WHERE module_name='shop'
  19. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  20. SELECT *
      FROM `jos_vm_product`
      WHERE `product_id`=107
      AND `product_publish`='Y'
  21. SELECT product_sku, related_products
      FROM jos_vm_product,jos_vm_product_relations
      WHERE jos_vm_product_relations.product_id='107'
      AND product_publish='Y'
      AND FIND_IN_SET(jos_vm_product.product_id, REPLACE(related_products, '|', ',' ))
      LIMIT 0, 4
  22. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='23'
      AND jos_vm_category.category_id='23'
  23. SELECT category_id, category_name,category_parent_id, category_child_id
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category_xref.category_child_id='6'
      AND jos_vm_category.category_id='6'
  24. SELECT id, params
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  25. SELECT COUNT(*) AS parentcnt
      FROM jos_vm_product
      WHERE product_parent_id>0
  26. SELECT DISTINCT `jos_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `jos_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `jos_vm_product`.`mdate`, `jos_vm_product`.`cdate`
      FROM (`jos_vm_product`, `jos_vm_category`, `jos_vm_product_category_xref`,`jos_vm_shopper_group`)
      LEFT JOIN `jos_vm_product_price`
      ON `jos_vm_product`.`product_id` = `jos_vm_product_price`.`product_id`
      WHERE `jos_vm_product_category_xref`.`product_id`=`jos_vm_product`.`product_id`
     
      AND `jos_vm_product_category_xref`.`category_id`=`jos_vm_category`.`category_id`
     
      AND ((`jos_vm_product`.`product_id`=`jos_vm_product_price`.`product_id`
      AND `jos_vm_shopper_group`.`shopper_group_id`=`jos_vm_product_price`.`shopper_group_id`) OR `jos_vm_product_price`.`product_id` IS NULL)
     
      AND `jos_vm_shopper_group`.`default` = 1
     
      AND `product_parent_id`=0
     
      AND `product_publish`='Y'
     
      AND `category_publish`='Y'
     
      GROUP BY `jos_vm_product`.`product_sku`
     
      ORDER BY `jos_vm_product`.`product_name` ASC
      LIMIT 0, 2000
  27. 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`='89'
  28. 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`='86'
  29. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 588)
      ORDER BY menuid DESC
      LIMIT 0, 1
  30. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='23'
  31. SELECT manufacturer_id
      FROM jos_vm_product_mf_xref
      WHERE product_id='107'
  32. SELECT mf_name,jos_vm_manufacturer.manufacturer_id
      FROM jos_vm_product_mf_xref,jos_vm_manufacturer
      WHERE product_id='107'
      AND jos_vm_manufacturer.manufacturer_id=jos_vm_product_mf_xref.manufacturer_id
  33. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='107'
  34. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  35. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  36. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=107
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  37. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='107'
      AND (start_date<='1716081292' OR start_date=0)
      AND (end_date>='1716075360' OR end_date=0)
      AND product_discount_id=discount_id
  38. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  39. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1716081292' OR start_date=0)
      AND (end_date>='1716075360' OR end_date=0)
      AND product_discount_id=discount_id
  40. SELECT tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=107
  41. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
  42. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=1
      AND `file_published`=1
  43. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=107
  44. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=1
      AND `file_published`=1
  45. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=107
      AND `file_is_image`=0
      AND `file_published`=1
  46. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  47. SELECT *
      FROM `jos_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
      AND `file_published`=1
  48. SELECT attribute_value
      FROM jos_vm_product_attribute
      WHERE `product_id` = '0'
      AND attribute_name='download'
  49. SELECT DISTINCT file_id, file_mimetype, file_title, file_name
      FROM `jos_vm_product_files`
      WHERE file_product_id = '0'
      AND file_published = '1'
      AND file_is_image = '0'
  50. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  51. SELECT COUNT(product_id) AS num_rows
      FROM jos_vm_product
      WHERE product_parent_id='107'
  52. SELECT votes, allvotes, rating
      FROM jos_vm_product_votes
      WHERE product_id='107'
  53. SELECT COUNT(*) AS num_rows
      FROM jos_vm_product_reviews
                                                   
      WHERE product_id='107'
      AND published='Y'
  54. SELECT comment, TIME, userid, user_rating
      FROM jos_vm_product_reviews
                                           
      WHERE product_id='107'
      AND published='Y'
      ORDER BY `time` DESC  
      LIMIT 0, 5
  55. SELECT jos_vm_vendor.vendor_name
      FROM jos_vm_product, jos_vm_vendor
      WHERE jos_vm_product.product_id='107'
      AND jos_vm_vendor.vendor_id=jos_vm_product.vendor_id
  56. SELECT *
      FROM jos_vm_product_product_type_xref
      WHERE product_id='107'
  57. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=107
  58. SELECT product_id, attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  59. SELECT product_id, attribute
      FROM jos_vm_product
      WHERE product_id='107'
  60. SELECT product_id, custom_attribute, product_parent_id
      FROM jos_vm_product
      WHERE product_id='107'
  61. SELECT product_id, custom_attribute
      FROM jos_vm_product
      WHERE product_id='107'
  62. SELECT product_id,product_name
      FROM jos_vm_product
      WHERE product_parent_id='107'
      AND product_publish='Y'
  63. SELECT `payment_method_id`
      FROM `jos_vm_payment_method`
      WHERE `payment_class`='ps_paypal_api'
      AND `payment_enabled`='Y'
  64. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 588 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  65. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='0'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  66. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='6'
  67. SELECT category_name, category_id, category_child_id
      FROM jos_vm_category AS a, jos_vm_category_xref AS b
      WHERE a.category_publish='Y'
      AND  b.category_parent_id='6'
      AND a.category_id=b.category_child_id
      ORDER BY category_parent_id, list_order, category_name ASC
  68. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='24'
  69. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='25'
  70. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='8'
  71. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='9'
  72. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='10'
  73. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='11'
  74. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='12'
  75. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='13'
  76. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='14'
  77. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='15'
  78. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='16'
  79. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='17'
  80. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='22'
  81. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='23'
  82. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='26'
  83. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='18'
  84. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='19'
  85. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='20'
  86. SELECT a.category_child_id AS id,a.category_parent_id AS parent, b.category_name AS name
      FROM jos_vm_category_xref AS a, jos_vm_category AS b
      WHERE b.category_publish = 'Y'
      AND b.category_id = a.category_child_id
      ORDER BY b.list_order, b.category_name
  87. SELECT currency_id, currency_code, currency_name
      FROM `jos_vm_currency`
      WHERE FIND_IN_SET(`currency_code`, 'COP,USD,')
      ORDER BY `currency_name`

Archivos de idioma cargados

Sin traducir las cadenas de diagnóstico

Ninguno

Sin traducir las cadenas de diseñador

Ninguno