Menu Content/Inhalt
Home
Sorteer op:

Vest

Marc O'Polo
€59,94
€10,00


Jas

Marc O'Polo
€75,95
€15,00


top

Sanetta
€9,95



jazz-pants

Sanetta
€8,95


top

Sanetta
€8,50
€5,95


jazz-pants

Sanetta
€6,50
€4,55




<< Begin < Vorige 1 2 3 Volgende > Einde >>

Toon #  
Resultaten 1 - 6 van 14
82 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 = 10083 ) ORDER BY menuid DESC LIMIT 1
3 DELETE FROM hh_jos_session WHERE ( ( time < '1283763275' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1283768375' ) AND guest = 1 AND userid = 0 )
4 SELECT session_id FROM hh_jos_session WHERE session_id = 'a9fc9287aeec182f2edd145a9cf1736d'
5 INSERT INTO hh_jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a9fc9287aeec182f2edd145a9cf1736d','1283769275','','0','1' )
6 SELECT * FROM hh_jos_menu WHERE id = 10083
7 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);
8 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'
9 SELECT `name` FROM `hh_jos_core_acl_aro_groups` WHERE `group_id` =29
10 SELECT `lft`, `rgt` FROM `hh_jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
11 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
12 SELECT `lft`, `rgt` FROM `hh_jos_core_acl_aro_groups` WHERE `name`='Public Backend'
13 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
14 SELECT module_perms FROM hh_jos_vm_module where module_name='shop'
15 SELECT id FROM hh_jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
16 SELECT category_id, category_description FROM hh_jos_vm_category WHERE category_id='83'
17 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 != ''
18 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`=83 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'
19 SELECT category_id, category_name FROM hh_jos_vm_category WHERE category_id='83'
20 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`=83 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
21 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='503'
22 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='503' AND (start_date<='1283769275' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
23 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='503'
24 SELECT shopper_group_id,shopper_group_discount FROM hh_jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
25 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='503'
26 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='503' 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
27 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='503'
28 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='503' AND shopper_group_id='5' ORDER BY price_quantity_start
29 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='503'
30 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='503'
31 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='598'
32 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='598' AND (start_date<='1283769275' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
33 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='598'
34 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='598'
35 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='598' 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
36 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='598'
37 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='598' AND shopper_group_id='5' ORDER BY price_quantity_start
38 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='598'
39 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='598'
40 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='41'
41 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='41' AND (start_date<='1283769275' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
42 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='41'
43 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='41'
44 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='41' 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
45 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='41'
46 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='41' AND shopper_group_id='5' ORDER BY price_quantity_start
47 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='41'
48 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='41'
49 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='42'
50 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='42' AND (start_date<='1283769275' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
51 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='42'
52 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='42'
53 SELECT product_price, product_price_id, product_currency FROM hh_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
54 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='42'
55 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='42' AND shopper_group_id='5' ORDER BY price_quantity_start
56 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='42'
57 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='42'
58 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='43'
59 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='43' AND (start_date<='1283769275' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
60 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='43'
61 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='43'
62 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='43' 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
63 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='43'
64 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='43' AND shopper_group_id='5' ORDER BY price_quantity_start
65 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='43'
66 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='43'
67 SELECT product_id, `product_name` FROM hh_jos_vm_product WHERE product_id='44'
68 SELECT amount,is_percent FROM hh_jos_vm_product,hh_jos_vm_product_discount WHERE product_id='44' AND (start_date<='1283769276' OR start_date=0) AND (end_date>='1283722560' OR end_date=0) AND product_discount_id=discount_id
69 SELECT vendor_id FROM hh_jos_vm_product WHERE product_id='44'
70 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='44'
71 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='44' 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
72 SELECT product_id, `product_parent_id` FROM hh_jos_vm_product WHERE product_id='44'
73 SELECT product_price, product_price_id, product_currency FROM hh_jos_vm_product_price WHERE product_id='44' AND shopper_group_id='5' ORDER BY price_quantity_start
74 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='44'
75 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='44'
76 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'
77 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 = 10083 ) ORDER BY ordering
78 SELECT id, name, link, parent, type, menutype, access FROM hh_jos_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
79 SELECT * FROM hh_jos_swmenu_config WHERE id = 48
80 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
81 SELECT * FROM hh_jos_swmenu_config WHERE id = 47
82 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