صفحه اول سایت کامپیوتر و فناوری اطلاعات بخش چهارم : چگونگي استـفاده از کلاس SQL Cache Dependencies فهرست مقالات صفحه اول سایت کامپیوتر و فناوری اطلاعات کنفرانس کامپیوتر عمران فنی و مهندسی علوم پایه علوم انسانی هنر و معماری شهر سازی نقشه برداری کشاورزی مکانیک معماری برق و الکترونیک مهندسی پزشکی طراحی صنعتی صنایع مدیریت جغرافیا فناوری نوین پزشکی مامایی ادبیات موسیقی اخترشناسی نمونه سوالات امتحانی معرفی رشته های دانشگاهی زندگی نامه بزرگان علم و ادب مطالب کوتاه منوی سایت معرفی اعضای همکلاسی سایت های علمی تماس با ما جستجو در سایت سلب مسئوليت اخبار همکلاسی افراد آنلاین 37 ميهمان فرم ورود نام كاربري رمز عبور من را به خاطر بسپار فراموش كردن رمز ثبت نام نكرده ايد؟ ثبت نام فروشگاه تیتانیوم و نقرهفروشگاه زیورآلات پارسیان - برای مشاهده تمام مقالات موجود در سایت و استفاده از تالار گفتمان لطفا با نام کاربری خود وارد شوید در صورتی که عضو نیستید < اینجا > کلیک کنید.  بخش چهارم : چگونگي استـفاده از کلاس SQL Cache Dependencies 1 2 3 4 5 (2 :مجموع راي ها) فرستادن : نوشته شده توسط فاطمه قدمیاری    عنوان مقاله بخش چهارم : چگونگي استـفاده از کلاس SQL Cache Dependencies نام نویسنده فاطمه قدمیاری پست الکترونیکی حجم فایل 908 کیلو بایت دریافت مقاله کلمات کلیدی مقاله : Caching Data with the ObjectDataSource - Caching Data in the Architecture - Notification – Polling - AspNet_SqlCacheTablesForChangeNotification - SQL cache dependency – trigger - aspnet_regsql.exe - SQL Server Management Studio – view state - page tracing - polling service - MasterCacheKeyArray - روش Caching - كلاس SqlCacheDependency - دو تکنیک تشخیص تغییر لایه های زیرین دیتا بیس – اخطار و نمونه برداری – دستورaspnet_regsql.exe - سيستم غيرمعتبر سازي Cache - سيستم آگاه سازي caching – سوئیچ ed - سوئيچ E – سوئيچ d - قوانين db ddladmin و db securityadmin - پايگاه داده ي pubs - مرجع قرار دادن یک دیتا بیس در App_Date - دیتابیس NORTHWND.MDF – پيكربندي polling service - خصوصیت EnableCaching - خصوصیت CacheDuration - خصوصیت OldValuesParameterFormatString - غير فعال كردن view state - خصوصیت EnableCaching متدAddCacheItem - متدAggregateCacheDependency’s Add - چکیده مقاله : ساده ترين استراتژي Caching اين است كه اجازه ي از بين رفتن داده ها را پس از مد ت مشخصي به داده ها بدهد. اما اين برداشت به اين معناست كه داده هاي نگهداري شده در Cache با منبع داده ي لايه هاي زيرين كاملا بي ارتباط است وباعث ماندگاري داده هاي قبلي و از بين رفتن سريع داده هاي جاري ميشود.يك برخورد بهتراين است كه ما از كلاس SqlCacheDependency استفاده كنيم و با استفاده ازاين كلاس داده ها تا زماني كه داده هاي لايه هاي زيرين در پايگاه داده ي SQL ويرايش نشده اند در Cache باقي مي مانند . در اين مبحث ما به توضيح چگونگي استفاده از اين كلاس به شرح زیر مي پردازيم. 1.کاوش دستور asp_regsql.exe 2.مرجع قرار دادن یک دیتا بیس در App_ Data 3.افزودن زیر بنای Polling به دیتا بیس Northwind 4.پیکربندی Polling Service 5.کار با SQL Cache Dependencies از طریق اعلان کردن 6.نکاتی در رابطه با ViewState 7.کار با کلاسSqlCacheDependency به شیوه برنامه نویسی 8.مرتبط کردن یک Cached Item با چند شیوه وابستگی نظرات افزودن جستجو متین (82.115.30.125) ۱۸ خرداد ۱۳۸۷ , ۲۳:۳۰ HI It was very usefull sincerly تنها کاربران عضو توانايي ارسال نظر را دارند. Powered by !JoomlaComment 3.1.1 Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved.   فرستادن : امکانات جدید سایت ارسال مقاله برای همکلاسی منابع کارشناسی ارشد - دروس و ضرایب منابع کارشناسی ارشد - منابع مطالعاتی پرسش و پاسخ لینک باکس مقالات عمران تبادل لینک تبلیغات در پایگاه همکلاسی آدرس وب سایت دانشگاه‌های ایران فروشگاه همکلاسی اخبار همکلاسی دوستان همکلاسی اطلاع رسانی کنفرانس‌ها فروشگاه همکلاسی برنامه نویسی توصیفی 60,000 ریال مجموعه اي از كتاب هاي الكترونيكي مهندسي - مهندسي كامپيوتر 40,000 ریال طراحی نرم افزارهای شی‌گرا و مهندسی نرم افزار 70,000 ریال سیستم های مدیریت پایگاه داده 50,000 ریال نظریه محاسبات 80,000 ریال تبلیغات آمار سایت اعضاء: 26986 تعداد مقالات: 24918 لينكها: 174 پراکندگی جغرافیایی کاربران RSS مقالات کامپیوتر و IT کنفرانس کامپیوتر  عمران معماری شهرسازی  مکانیک  برق و الکترونیک طراحی صنعتی مهندسی پزشکی جغرافیا فناوری نوین پزشکی مامایی ادبیات موسیقی اختر شناسی نمونه سوالات معرفی رشته زندگی نامه ها مطالب کوتاه    راهنمای RSS را مطالعه کنید ... کلیه مقالات پایگاه علمی همکلاسی تحت مجوز Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License منتشر می‌گردد. Template Designed by : Template Design Workshop Template name : Hamkelasy Template Designed by : Template Design Workshop Template Design Workshop offers professional web templates, flash templates and other web design products available for immediate download. PictoFX Multimedia Design Group Medium Blog Template Design Workshop pictofxt pictofxt

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 42 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1265728422' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265728422' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT *
 FROM jos_session
 WHERE session_id = '20b4cf895807cd67152587171cfb6955'
5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'd7ea37efc9e3c5f38fe80c6ed32e2cb9'
6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd7ea37efc9e3c5f38fe80c6ed32e2cb9','1265729322','','0','1' )
7
SELECT *
 FROM jos_menu
 WHERE id = 42
8
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 2656 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-02-09 18:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-09 18:58' )
 AND a.access <= 0
9
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 2656
10
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '2656'
11
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
12
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
13
SELECT params
 FROM jos_mambots
 WHERE element = 'sociotag'
 AND folder = 'content'
14
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
15
SHOW TABLES LIKE 'jos_comprofiler';
16
SELECT * FROM jos_comment WHERE contentid='2656' AND published='1' ORDER BY id ASC
17
SELECT * FROM jos_users WHERE id='11456' LIMIT 1
18
SELECT params
 FROM jos_mambots
 WHERE element = 'josBWrewi'
 AND folder = 'content'
19
select id from jos_menu where published = '1' and (type = 'content_item_link' OR type = 'content_typed') and componentid='2656';
20
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 2656
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
21
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
22
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
23
SELECT *
 FROM jos_mambots
 WHERE id = '25'
24
SELECT * FROM jos_content_rating WHERE content_id=2656
25
select id from jos_menu where published = '1' and (type = 'content_item_link' OR type = 'content_typed') and componentid='2656';
26
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'
27
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 = 42 )
 ORDER BY ordering
28
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
29
SELECT title, catid, id
 FROM jos_content
 WHERE id = 2656
 AND access <= 0
30
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
31
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
32
SELECT guest, usertype
 FROM jos_session
33
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0
34
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=2 )
35
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 24
36
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )
37
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 29
38
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
39
SELECT *
 FROM jos_mambots
 WHERE id = '25'
40
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=1 )
41
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 25
42
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )
43
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 29
44
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'left menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
45
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
46
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=428'
47
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=637'
48
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);
49
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'
50
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
51
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
52
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 3 AND 12
GROUP BY g1.name
ORDER BY g1.lft
53
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
54
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
55
SELECT p.product_sku FROM jos_vm_product AS p
JOIN jos_vm_product_category_xref as pc ON p.product_id=pc.product_id AND (pc.category_id=14 
OR pc.category_id=15 
) 
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
56
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='comco6'
57
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='155' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
58
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`='155'
59
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
60
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='155'
61
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='155' AND (start_date<='1265729322' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
62
SELECT vendor_id FROM jos_vm_product WHERE product_id='155'
63
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
64
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='155'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='155' 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
66
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='155'
67
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='155' AND shopper_group_id='5'  ORDER BY price_quantity_start
68
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='155'
69
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
70
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='comB08'
71
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='151' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
72
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`='151'
73
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='151'
74
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='151' AND (start_date<='1265729322' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
75
SELECT vendor_id FROM jos_vm_product WHERE product_id='151'
76
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='151'
77
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='151' 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
78
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='151'
79
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='151' AND shopper_group_id='5'  ORDER BY price_quantity_start
80
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='151'
81
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
82
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='comco1'
83
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='3' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
84
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`='3'
85
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='3'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='3' AND (start_date<='1265729322' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
87
SELECT vendor_id FROM jos_vm_product WHERE product_id='3'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='3'
89
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='3' 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
90
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='3'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='3' AND shopper_group_id='5'  ORDER BY price_quantity_start
92
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='3'
93
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
94
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='comco5'
95
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='7' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
96
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`='7'
97
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='7'
98
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='7' AND (start_date<='1265729322' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
99
SELECT vendor_id FROM jos_vm_product WHERE product_id='7'
100
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='7'
101
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='7' 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
102
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='7'
103
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='7' AND shopper_group_id='5'  ORDER BY price_quantity_start
104
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='7'
105
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
106
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='comco3'
107
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='5' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
108
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`='5'
109
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='5'
110
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='5' AND (start_date<='1265729322' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
111
SELECT vendor_id FROM jos_vm_product WHERE product_id='5'
112
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='5'
113
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='5' 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
114
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='5'
115
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='5' AND shopper_group_id='5'  ORDER BY price_quantity_start
116
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='5'
117
SELECT tax_rate FROM jos_vm_vendor, jos_vm_tax_rate WHERE tax_country=vendor_country AND jos_vm_vendor.vendor_id='1' ORDER BY `tax_rate` DESC
118
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=3 )
119
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 30
120
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
121
SELECT *
 FROM jos_mambots
 WHERE id = '25'
122
SELECT COUNT( id ) AS count_users
 FROM jos_users
123
SELECT COUNT( id ) AS count_items
 FROM jos_content
124
SELECT COUNT( id ) AS count_links
 FROM jos_weblinks
 WHERE published = 1
125
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
126
SELECT *
 FROM jos_mambots
 WHERE id = '25'
127
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
128
SELECT *
 FROM jos_mambots
 WHERE id = '25'
129
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
130
SELECT *
 FROM jos_mambots
 WHERE id = '25'