Slayt

Seçtiklerimiz

EFCO EFCO SA3000 Toplama Çantası
EFCO EFCO SA3000 Toplama Çantası
 Fiyatlar için arayabilirsiniz.		 BG-DP 6015 N DALGIÇ POMPA (Kirli Su)
BG-DP 6015 N DALGIÇ POMPA (Kirli Su)
 Fiyatlar için arayabilirsiniz.

Eklediklerimiz

REH 680 ELEKTRİKLİ ÇİT BUDAMA
REH 680 ELEKTRİKLİ ÇİT BUDAMA
 Fiyatlar için arayabilirsiniz.		 BG-WW 1140 N HİDROFOR
BG-WW 1140 N HİDROFOR
 Fiyatlar için arayabilirsiniz.
Faydalı Bilgiler
Sitemize Hoşgeldiniz PDF  | Yazdır |  E-posta
Son Güncelleme ( Perşembe, 01 Mayıs 2008 )
 
[ Geri ]
177 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 9 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1328714716' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328714716' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT *
 FROM jos_menu
 WHERE id = 9
13
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 17:40' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 17:40' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
14
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-08 17:40' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-08 17:40' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 10
15
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
16
SELECT a.*
 FROM 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'
17
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN 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 = 9 )
 ORDER BY ordering
18
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
19
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
20
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 (`jos_vm_vendor`, `jos_vm_country`)
		WHERE `vendor_id`=1
		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
21
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'
22
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
23
SELECT g1.group_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

GROUP BY g1.name
ORDER BY g1.lft
24
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
25
SELECT g1.group_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
26
SELECT DISTINCT product_sku FROM jos_vm_product WHERE product_parent_id='' AND vendor_id='1' AND jos_vm_product.product_publish='Y' ORDER BY product_name DESC
27
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='24040907'
28
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='278' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
29
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`='278'
30
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
31
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='278'
32
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='278' AND (start_date<='1328715621' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
33
SELECT vendor_id FROM jos_vm_product WHERE product_id='278'
34
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
35
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='278'
36
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
39
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
40
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='278'
41
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' AND shopper_group_id='5'  ORDER BY price_quantity_start
42
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='278' AND shopper_group_id='5'  ORDER BY price_quantity_start
43
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
44
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
45
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='08011014'
46
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='353' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
47
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`='353'
48
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='353'
49
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='353' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
50
SELECT vendor_id FROM jos_vm_product WHERE product_id='353'
51
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='353'
52
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='353' 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
53
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='353' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
56
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='353'
57
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='353' AND shopper_group_id='5'  ORDER BY price_quantity_start
58
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='353' AND shopper_group_id='5'  ORDER BY price_quantity_start
59
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
60
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
61
SELECT DISTINCT product_sku FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category WHERE product_parent_id=''AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_publish='Y' ORDER BY jos_vm_product.product_id DESC LIMIT 0, 2
62
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='08011018'
63
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='357' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
64
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`='357'
65
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='357'
66
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='357' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
67
SELECT vendor_id FROM jos_vm_product WHERE product_id='357'
68
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='357'
69
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='357' 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
70
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='357' 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
71
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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 jos_vm_product WHERE product_id='357'
74
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='357' AND shopper_group_id='5'  ORDER BY price_quantity_start
75
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='357' AND shopper_group_id='5'  ORDER BY price_quantity_start
76
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
77
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
78
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='08011017'
79
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='356' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
80
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`='356'
81
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='356'
82
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='356' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
83
SELECT vendor_id FROM jos_vm_product WHERE product_id='356'
84
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='356'
85
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='356' 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
86
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='356' 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
87
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
88
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
89
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='356'
90
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='356' AND shopper_group_id='5'  ORDER BY price_quantity_start
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='356' AND shopper_group_id='5'  ORDER BY price_quantity_start
92
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
93
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
94
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
95
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu1'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
96
SELECT p.product_sku FROM jos_vm_product AS p
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
97
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='080101001'
98
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='341' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
99
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`='341'
100
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='341'
101
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='341' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
102
SELECT vendor_id FROM jos_vm_product WHERE product_id='341'
103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='341'
104
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='341' 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
105
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='341' 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
106
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
107
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
108
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='341'
109
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='341' AND shopper_group_id='5'  ORDER BY price_quantity_start
110
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='341' AND shopper_group_id='5'  ORDER BY price_quantity_start
111
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
112
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
113
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='280908003'
114
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='229' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
115
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`='229'
116
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='229'
117
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='229' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
118
SELECT vendor_id FROM jos_vm_product WHERE product_id='229'
119
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='229'
120
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='229' 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
121
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='229' 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
122
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
123
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
124
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='229'
125
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='229' AND shopper_group_id='5'  ORDER BY price_quantity_start
126
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='229' AND shopper_group_id='5'  ORDER BY price_quantity_start
127
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
128
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
129
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='26070801'
130
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='174' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
131
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`='174'
132
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='174'
133
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='174' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
134
SELECT vendor_id FROM jos_vm_product WHERE product_id='174'
135
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='174'
136
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='174' 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
137
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='174' 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
138
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
139
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
140
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='174'
141
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='174' AND shopper_group_id='5'  ORDER BY price_quantity_start
142
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='174' AND shopper_group_id='5'  ORDER BY price_quantity_start
143
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
144
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
145
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='25040901'
146
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='279' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
147
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`='279'
148
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='279'
149
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='279' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
150
SELECT vendor_id FROM jos_vm_product WHERE product_id='279'
151
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='279'
152
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='279' 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
153
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='279' 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
154
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
155
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
156
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='279'
157
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='279' AND shopper_group_id='5'  ORDER BY price_quantity_start
158
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='279' AND shopper_group_id='5'  ORDER BY price_quantity_start
159
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
160
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
161
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='453'
162
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='95' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
163
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`='95'
164
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='95'
165
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='95' AND (start_date<='1328715622' OR start_date=0) AND (end_date>='1328650560' OR end_date=0) AND product_discount_id=discount_id
166
SELECT vendor_id FROM jos_vm_product WHERE product_id='95'
167
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='95'
168
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' 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
169
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' 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
170
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
171
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' 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
172
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='95'
173
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' AND shopper_group_id='5'  ORDER BY price_quantity_start
174
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='95' AND shopper_group_id='5'  ORDER BY price_quantity_start
175
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
176
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='0' AND shopper_group_id='5'  ORDER BY price_quantity_start
177
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering