Menu Content/Inhalt
Home
Sorteer op:

shorts 2-pack

Muchachomalo
€19,95
€16,96


shorts 2-pack

Muchachomalo
€19,95
€16,96


singlet

Muchachomalo
€19,95
€16,96



Singlet

Muchachomalo
€19,95
€16,96


Shorts 2-pack

Muchachomalo
€19,95
€16,96



59 queries executed
1
SELECT folder, element, published, params
 FROM hh_jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2 SELECT template FROM hh_jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 10081 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM hh_jos_session WHERE ( ( time < '1283767585' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283772685' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM hh_jos_session WHERE session_id = '080f86cd2c2ed49fe71cbf3d76003f98'
5 SELECT session_id FROM hh_jos_session WHERE session_id = '8392aa718ee3bc618b2150fb5be40263'
6 INSERT INTO hh_jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '8392aa718ee3bc618b2150fb5be40263','1283773585','','0','1' )
7 SELECT * FROM hh_jos_menu WHERE id = 10081
8 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 FROM (`hh_jos_vm_vendor`, `hh_jos_vm_country`) WHERE `vendor_id`=1 AND (vendor_country=country_2_code OR vendor_country=country_3_code);
9 SELECT hh_jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount FROM `hh_jos_vm_shopper_group` WHERE hh_jos_vm_shopper_group.vendor_id='1' AND `default`='1'
10 SELECT `name` FROM `hh_jos_core_acl_aro_groups` WHERE `group_id` =29
11 SELECT `lft`, `rgt` FROM `hh_jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
12 SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM hh_jos_core_acl_aro_groups AS g1 INNER JOIN hh_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
13 SELECT `lft`, `rgt` FROM `hh_jos_core_acl_aro_groups` WHERE `name`='Public Backend'
14 SELECT g1.group_id, g1.name, COUNT(g2.name) AS level FROM hh_jos_core_acl_aro_groups AS g1 INNER JOIN hh_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
15 SELECT module_perms FROM hh_jos_vm_module where module_name='shop'
16 SELECT id FROM hh_jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
17 SELECT category_id, category_description FROM hh_jos_vm_category WHERE category_id='81'
18 SELECT hh_jos_users.id, hh_jos_vm_user_info.user_id from hh_jos_users, hh_jos_vm_user_info WHERE hh_jos_users.id='0' AND hh_jos_users.id=hh_jos_vm_user_info.user_id AND hh_jos_vm_user_info.address_type='BT' AND hh_jos_vm_user_info.first_name != '' AND hh_jos_vm_user_info.last_name != '' AND hh_jos_vm_user_info.city != ''
19 SELECT COUNT(DISTINCT `hh_jos_vm_product`.`product_sku`) as num_rows FROM (`hh_jos_vm_product`, `hh_jos_vm_category`, `hh_jos_vm_product_category_xref`,`hh_jos_vm_shopper_group`) LEFT JOIN `hh_jos_vm_product_price` ON `hh_jos_vm_product`.`product_id` = `hh_jos_vm_product_price`.`product_id` WHERE `hh_jos_vm_product_category_xref`.`product_id`=`hh_jos_vm_product`.`product_id` AND `hh_jos_vm_product_category_xref`.`category_id`=`hh_jos_vm_category`.`category_id` AND `hh_jos_vm_product_category_xref`.`category_id`=81 AND ((`hh_jos_vm_product`.`product_id`=`hh_jos_vm_product_price`.`product_id` AND `hh_jos_vm_shopper_group`.`shopper_group_id`=`hh_jos_vm_product_price`.`shopper_group_id`) OR `hh_jos_vm_product_price`.`product_id` IS NULL) AND `hh_jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y'
20 SELECT category_id, category_name FROM hh_jos_vm_category WHERE category_id='81'
21 SELECT DISTINCT `product_name`,`products_per_row`,`category_browsepage`,`category_flypage`,`hh_jos_vm_category`.`category_id`, `hh_jos_vm_product`.`product_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_in_stock`,`product_available_date`,`product_availability`,`hh_jos_vm_product`.`mdate`, `hh_jos_vm_product`.`cdate` FROM (`hh_jos_vm_product`, `hh_jos_vm_category`, `hh_jos_vm_product_category_xref`,`hh_jos_vm_shopper_group`) LEFT JOIN `hh_jos_vm_product_price` ON `hh_jos_vm_product`.`product_id` = `hh_jos_vm_product_price`.`product_id` WHERE `hh_jos_vm_product_category_xref`.`product_id`=`hh_jos_vm_product`.`product_id` AND `hh_jos_vm_product_category_xref`.`category_id`=`hh_jos_vm_category`.`category_id` AND `hh_jos_vm_product_category_xref`.`category_id`=81 AND ((`hh_jos_vm_product`.`product_id`=`hh_jos_vm_product_price`.`product_id` AND `hh_jos_vm_shopper_group`.`shopper_group_id`=`hh_jos_vm_product_price`.`shopper_group_id`) OR `hh_jos_vm_product_price`.`product_id` IS NULL) AND `hh_jos_vm_shopper_group`.`default` = 1 AND `product_parent_id`=0 AND `product_publish`='Y' GROUP BY `hh_jos_vm_product`.`product_sku` ORDER BY `hh_jos_vm_product`.`product_sku` ASC LIMIT 0, 6
22 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='562'
23 SELECT shopper_group_id,shopper_group_discount FROM hh_jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
24 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='562'
25 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='562' 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
26 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='562'
27 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='562' AND shopper_group_id='5' ORDER BY price_quantity_start
28 SELECT DISTINCT hh_jos_vm_manufacturer.manufacturer_id, hh_jos_vm_manufacturer.mf_name,hh_jos_vm_product_mf_xref.product_id FROM hh_jos_vm_manufacturer,hh_jos_vm_product_mf_xref WHERE hh_jos_vm_manufacturer.manufacturer_id = hh_jos_vm_product_mf_xref.manufacturer_id AND hh_jos_vm_product_mf_xref.product_id='562'
29 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='561'
30 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='561'
31 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='561' 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
32 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='561'
33 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='561' AND shopper_group_id='5' ORDER BY price_quantity_start
34 SELECT DISTINCT hh_jos_vm_manufacturer.manufacturer_id, hh_jos_vm_manufacturer.mf_name,hh_jos_vm_product_mf_xref.product_id FROM hh_jos_vm_manufacturer,hh_jos_vm_product_mf_xref WHERE hh_jos_vm_manufacturer.manufacturer_id = hh_jos_vm_product_mf_xref.manufacturer_id AND hh_jos_vm_product_mf_xref.product_id='561'
35 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='563'
36 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='563'
37 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='563' 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
38 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='563'
39 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='563' AND shopper_group_id='5' ORDER BY price_quantity_start
40 SELECT DISTINCT hh_jos_vm_manufacturer.manufacturer_id, hh_jos_vm_manufacturer.mf_name,hh_jos_vm_product_mf_xref.product_id FROM hh_jos_vm_manufacturer,hh_jos_vm_product_mf_xref WHERE hh_jos_vm_manufacturer.manufacturer_id = hh_jos_vm_product_mf_xref.manufacturer_id AND hh_jos_vm_product_mf_xref.product_id='563'
41 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='570'
42 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='570'
43 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='570' 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
44 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='570'
45 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='570' AND shopper_group_id='5' ORDER BY price_quantity_start
46 SELECT DISTINCT hh_jos_vm_manufacturer.manufacturer_id, hh_jos_vm_manufacturer.mf_name,hh_jos_vm_product_mf_xref.product_id FROM hh_jos_vm_manufacturer,hh_jos_vm_product_mf_xref WHERE hh_jos_vm_manufacturer.manufacturer_id = hh_jos_vm_product_mf_xref.manufacturer_id AND hh_jos_vm_product_mf_xref.product_id='570'
47 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='569'
48 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='569'
49 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='569' 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
50 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='569'
51 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='569' AND shopper_group_id='5' ORDER BY price_quantity_start
52 SELECT DISTINCT hh_jos_vm_manufacturer.manufacturer_id, hh_jos_vm_manufacturer.mf_name,hh_jos_vm_product_mf_xref.product_id FROM hh_jos_vm_manufacturer,hh_jos_vm_product_mf_xref WHERE hh_jos_vm_manufacturer.manufacturer_id = hh_jos_vm_product_mf_xref.manufacturer_id AND hh_jos_vm_product_mf_xref.product_id='569'
53 SELECT a.* FROM hh_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'
54 SELECT id, title, module, position, content, showtitle, params FROM hh_jos_modules AS m INNER JOIN hh_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 = 10081 ) ORDER BY ordering
55 SELECT id, name, link, parent, type, menutype, access FROM hh_jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
56 SELECT * FROM hh_jos_swmenu_config WHERE id = 48
57 SELECT hh_jos_vm_category.* , hh_jos_swmenu_extended.*,hh_jos_vm_category_xref.* FROM hh_jos_vm_category LEFT JOIN hh_jos_swmenu_extended ON hh_jos_vm_category.category_id = hh_jos_swmenu_extended.menu_id AND (hh_jos_swmenu_extended.moduleID = '48' OR hh_jos_swmenu_extended.moduleID IS NULL) INNER JOIN hh_jos_vm_category_xref ON hh_jos_vm_category_xref.category_child_id= hh_jos_vm_category.category_id AND hh_jos_vm_category.category_publish = 'Y' ORDER BY hh_jos_vm_category.list_order
58 SELECT * FROM hh_jos_swmenu_config WHERE id = 47
59 SELECT hh_jos_menu.* , hh_jos_swmenu_extended.* FROM hh_jos_menu LEFT JOIN hh_jos_swmenu_extended ON hh_jos_menu.id = hh_jos_swmenu_extended.menu_id AND (hh_jos_swmenu_extended.moduleID = '47' OR hh_jos_swmenu_extended.moduleID IS NULL) WHERE hh_jos_menu.menutype = 'mainmenu' AND published = '1' ORDER BY parent, ordering