Menu Content/Inhalt
Home
Sorteer op:

Shorts 2-pack

Chicamala
€19,95
€16,96


Top

Chicamala
€19,95
€16,96


Shorts 2-pack

Chicamala
€19,95
€16,96



Top

Chicamala
€19,95
€16,96


pyjama

Sanetta
€37,95
€26,56


pyjama

Sanetta
€39,95
€29,96




<< Begin < Vorige 1 2 3 4 5 6 Volgende > Einde >>

Toon #  
Resultaten 1 - 6 van 36
83 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 = 10091 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM hh_jos_session WHERE ( ( time < '1283763463' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283768563' ) AND guest = 1 AND userid = 0 )
4 SELECT * FROM hh_jos_session WHERE session_id = 'cb7e6ee52b6a5994cbbea11169f579c3'
5 SELECT session_id FROM hh_jos_session WHERE session_id = '5dc3741d1f9b1e5e50e6a3d580130f59'
6 INSERT INTO hh_jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '5dc3741d1f9b1e5e50e6a3d580130f59','1283769463','','0','1' )
7 SELECT * FROM hh_jos_menu WHERE id = 10091
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='91'
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`=91 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='91'
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`=91 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='568'
23 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='568' AND (start_date<='1283769464' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
24 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='568'
25 SELECT shopper_group_id,shopper_group_discount FROM hh_jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
26 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='568'
27 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='568' 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
28 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='568'
29 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='568' AND shopper_group_id='5' ORDER BY price_quantity_start
30 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='568'
31 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='568'
32 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='571'
33 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='571' AND (start_date<='1283769465' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
34 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='571'
35 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='571'
36 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='571' 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
37 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='571'
38 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='571' AND shopper_group_id='5' ORDER BY price_quantity_start
39 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='571'
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='571'
41 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='572'
42 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='572' AND (start_date<='1283769465' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
43 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='572'
44 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='572'
45 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='572' 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
46 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='572'
47 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='572' AND shopper_group_id='5' ORDER BY price_quantity_start
48 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='572'
49 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='572'
50 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='573'
51 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='573' AND (start_date<='1283769465' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
52 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='573'
53 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='573'
54 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='573' 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
55 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='573'
56 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='573' AND shopper_group_id='5' ORDER BY price_quantity_start
57 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='573'
58 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='573'
59 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='287'
60 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='287' AND (start_date<='1283769465' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
61 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='287'
62 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='287'
63 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='287' 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
64 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='287'
65 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='287' AND shopper_group_id='5' ORDER BY price_quantity_start
66 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='287'
67 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='287'
68 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='474'
69 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='474' AND (start_date<='1283769466' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
70 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='474'
71 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='474'
72 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='474' 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 hh_jos_vm_product WHERE product_id='474'
74 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='474' AND shopper_group_id='5' ORDER BY price_quantity_start
75 SELECT product_weight, tax_rate FROM hh_jos_vm_product, hh_jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='474'
76 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='474'
77 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'
78 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 = 10091 ) ORDER BY ordering
79 SELECT id, name, link, parent, type, menutype, access FROM hh_jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
80 SELECT * FROM hh_jos_swmenu_config WHERE id = 48
81 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
82 SELECT * FROM hh_jos_swmenu_config WHERE id = 47
83 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