Slayt

Seçtiklerimiz

OLEOMAC G 53 PBX Comfort Çim Biçme Makinası
OLEOMAC G 53 PBX Comfort Çim Biçme Makinası
 Fiyatlar için arayabilirsiniz.		 EFCO 152 Motorlu Testere
EFCO 152 Motorlu Testere
 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 < '1337538727' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1337538727' )
 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-05-20 21:47' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:47' )
 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-05-20 21:47' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 21:47' )
 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='25040902'
28
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='280' 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`='280'
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='280'
32
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='280' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
33
SELECT vendor_id FROM jos_vm_product WHERE product_id='280'
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='280'
36
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='280' 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='280' 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='280'
41
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='280' 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='280' 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='152'
46
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='27' 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`='27'
48
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='27'
49
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='27' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
50
SELECT vendor_id FROM jos_vm_product WHERE product_id='27'
51
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='27'
52
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='27' 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='27' 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='27'
57
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='27' 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='27' 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<='1337539627' OR start_date=0) AND (end_date>='1337459760' 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<='1337539627' OR start_date=0) AND (end_date>='1337459760' 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='440'
98
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='94' 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`='94'
100
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='94'
101
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='94' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
102
SELECT vendor_id FROM jos_vm_product WHERE product_id='94'
103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='94'
104
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='94' 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='94' 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='94'
109
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='94' 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='94' 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='0250220'
114
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='126' 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`='126'
116
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='126'
117
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='126' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
118
SELECT vendor_id FROM jos_vm_product WHERE product_id='126'
119
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='126'
120
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='126' 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='126' 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='126'
125
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='126' 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='126' 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='03030902'
130
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='234' 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`='234'
132
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='234'
133
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='234' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
134
SELECT vendor_id FROM jos_vm_product WHERE product_id='234'
135
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='234'
136
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='234' 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='234' 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='234'
141
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='234' 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='234' 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='8100'
146
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='56' 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`='56'
148
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='56'
149
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='56' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
150
SELECT vendor_id FROM jos_vm_product WHERE product_id='56'
151
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='56'
152
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='56' 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='56' 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='56'
157
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='56' 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='56' 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='215'
162
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='36' 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`='36'
164
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='36'
165
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='36' AND (start_date<='1337539627' OR start_date=0) AND (end_date>='1337459760' OR end_date=0) AND product_discount_id=discount_id
166
SELECT vendor_id FROM jos_vm_product WHERE product_id='36'
167
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='36'
168
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='36' 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='36' 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='36'
173
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='36' 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='36' 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