Connexion, créer un nouveau compte ou continuer sans enregistrement

SELECT `data`

  FROM `tcp_session`

  WHERE `session_id` = 'i5pqkfeqdjsht6dlujpq5ve164'

SELECT id, rules

  FROM `tcp_viewlevels`

SELECT b.id

  FROM tcp_usergroups AS a

  LEFT JOIN tcp_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

UPDATE `tcp_extensions`

  SET `params` = '{\"mediaversion\":\"6c8c819f6e3cead86c9914e5323f3586\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

SELECT * 
  FROM tcp_hikashop_config

SELECT cart.cart_id 
  FROM tcp_hikashop_cart AS cart  
  WHERE (cart.cart_type = 'cart') 
  AND (cart.session_id = 'i5pqkfeqdjsht6dlujpq5ve164')  
  ORDER BY cart.cart_current DESC, cart.cart_modified DESC

SELECT * 
  FROM tcp_hikashop_cart 
  WHERE cart_id = '93786' 
  LIMIT 0, 1

SELECT cart_product.*, product.product_type, product.product_parent_id  
  FROM tcp_hikashop_cart_product AS cart_product  
  LEFT JOIN tcp_hikashop_product AS product 
  ON cart_product.product_id = product.product_id  
  WHERE (cart_product.cart_id = 93786) 
  AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%'))  
  ORDER BY cart_product.cart_product_modified ASC

SELECT plugin_id as id, plugin_name as name 
  FROM tcp_hikashop_plugin 
  WHERE (plugin_type = 'shopclosehours') 
  AND (plugin_published = 1) 
  ORDER BY plugin_ordering

SELECT shipping_id, shipping_params 
  FROM tcp_hikashop_shipping 
  WHERE shipping_id IN(32)

SELECT currency_id 
  FROM tcp_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1

SELECT cart_product.cart_product_id, cart_product.cart_product_quantity, cart_product.cart_product_option_parent_id, cart_product.cart_product_parent_id, cart_product.cart_product_wishlist_id, product.*  
  FROM tcp_hikashop_cart_product AS cart_product  
  LEFT JOIN tcp_hikashop_product AS product 
  ON cart_product.product_id = product.product_id  
  WHERE (cart_product.cart_id = 93786) 
  AND (cart_product.product_id > 0) 
  AND ((product.product_access = 'all' OR product.product_access LIKE '%,9,%'))  
  ORDER BY cart_product.cart_product_id ASC

SELECT pr.product_id, pr.product_related_id, pr.product_related_quantity, FLOOR(p.product_quantity / pr.product_related_quantity) as bundle_quantity  
  FROM tcp_hikashop_product_related AS pr  
  INNER JOIN tcp_hikashop_product AS p 
  ON pr.product_related_id = p.product_id  
  WHERE pr.product_id IN (4) 
  AND pr.product_related_type = 'bundle' 
  AND p.product_quantity >= 0

SELECT DISTINCT hk_limit.*  
  FROM tcp_hikashop_limit AS hk_limit  
  LEFT JOIN tcp_hikashop_product_category AS hk_pc 
  ON (hk_limit.limit_category_id = hk_pc.category_id)  
  WHERE (hk_limit.limit_published = 1) 
  AND (hk_limit.limit_start = 0 OR hk_limit.limit_start <= 1715372539) 
  AND (hk_limit.limit_end = 0 OR hk_limit.limit_end >= 1715372539) 
  AND (hk_limit.limit_product_id IN (0,4)) 
  AND (hk_limit.limit_category_id = 0 OR hk_pc.product_id IN (0,4)) 
  AND ((hk_limit.limit_access = 'all' OR hk_limit.limit_access LIKE '%,9,%'))

SELECT * 
  FROM tcp_hikashop_file 
  WHERE file_ref_id IN (4) 
  AND file_type IN ('product','file')  
  ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC

SELECT product_category.*, category.*  
  FROM tcp_hikashop_product_category AS product_category  
  LEFT JOIN tcp_hikashop_category AS category 
  ON product_category.category_id = category.category_id  
  WHERE product_category.product_id IN (4) 
  ORDER BY product_category.ordering ASC

SELECT hk_variant.*, hk_characteristic.*  
  FROM tcp_hikashop_variant AS hk_variant  
  LEFT JOIN tcp_hikashop_characteristic AS hk_characteristic 
  ON hk_variant.variant_characteristic_id = hk_characteristic.characteristic_id  
  WHERE hk_variant.variant_product_id IN (4)  
  ORDER BY hk_variant.ordering, hk_characteristic.characteristic_value

SELECT category_id 
  FROM tcp_hikashop_product_category 
  WHERE product_id IN (4) 
  ORDER BY ordering ASC

SELECT hk_parent.* 
  FROM tcp_hikashop_category AS hk_cat  
  LEFT JOIN tcp_hikashop_category AS hk_parent 
  ON (hk_parent.category_left <= hk_cat.category_left 
  AND hk_parent.category_right >= hk_cat.category_right)  
  WHERE  hk_cat.category_id IN (2,28,18,16,13)  
  GROUP BY hk_parent.category_id  
  ORDER BY hk_parent.category_left