صفحه اول سایت شهر سازی فهرست مقالات صفحه اول سایت کامپیوتر و فناوری اطلاعات کنفرانس کامپیوتر عمران فنی و مهندسی علوم پایه علوم انسانی هنر و معماری شهر سازی نقشه برداری کشاورزی مکانیک معماری برق و الکترونیک مهندسی پزشکی طراحی صنعتی صنایع مدیریت جغرافیا فناوری نوین پزشکی مامایی ادبیات موسیقی اخترشناسی نمونه سوالات امتحانی معرفی رشته های دانشگاهی زندگی نامه بزرگان علم و ادب مطالب کوتاه منوی سایت معرفی اعضای همکلاسی سایت های علمی تماس با ما جستجو در سایت سلب مسئوليت اخبار همکلاسی افراد آنلاین 17 ميهمان فرم ورود نام كاربري رمز عبور من را به خاطر بسپار فراموش كردن رمز ثبت نام نكرده ايد؟ ثبت نام  فروشگاه تیتانیوم و نقرهفروشگاه زیورآلات پارسیان - برای مشاهده تمام مقالات موجود در سایت و استفاده از تالار گفتمان لطفا با نام کاربری خود وارد شوید در صورتی که عضو نیستید < اینجا > کلیک کنید. شهرسازی جستجوی واژه     مرتب سازی بر حسب  الفبایی از آ القبایی از ی بیشترین بازدید کمترین بازدید نام نویسنده الفبایی از آ نام نویسنده الفبایی از ی مرتب سازي    نمايش #  5 10 15 20 25 30 50 نام موضوع نويسنده تعداد بازدید تاثيرگذاري شهرهای جدید پیوسته در ساماندهی مادر شهر اصفهان جواد 146 شهر فرهنگي.فرهنگ شهري علي كامل 5120 نظریات فرانک لوید رایت در شهرسازی محمد شهسواری 7288 هگمتانه - بخش دوم یک شهر 3317 هگمتانه - بخش اول یک شهر 3569 زاغه نشینی تارا مقصودنیا 3868 مکتب شیکاگو امیر فرشچین 5615 بررسي تاريخي انجمن هاي شهر تا شوراهاي اسلامي با تاكيد بر مدیریت شهری محمدرضا مُنعام 9228 اكوتوريسم تحول استراتژي اقتصادي در ايران شهربانو شبستانی 5834 اشتغال زنان در ايران مینا پریناز 6636 فرم شهر مریم 5918 جهاني شدن و مشكل كلان شهر ها مریم 5339 فرهنگ و شهر مریم 4174 منابع کنکور ارشد مریم 14544 جایگاه طراحی شهری در نظام شهرسازی مریم 5013 نمایشی در شهر مریم 2671 جایگاه طراحی شهری در طرحهای توسعه شهری مریم 4342 نوشهرها مریم 3527 پست مدرنیسم مریم 5400 منابع کارشناسی ارشد مریم 12237 سیمای بد قواره شهر ما مریم 4064 تاریخچه پیدایش جلفا مریم 2731 میدان شهری مریم 4608 بافت های فرسوده مریم 7294 کنترل بازار مسکن در کلان شهر ها مریم 2952 تراکم در شهر مریم 4395 اشنایی با برخی مفاهیم فضای شهری مریم 6525 مفهوم زمان در شهرسازی مریم اسعدی 5461 مدیریت زباله های شهری مریم اسعدی 10076 زباله های شهری مریم اسعدی 5686 طبقه بندی مواد زائد جامد شهری مریم اسعدی 9502 گرافیک محیطی مریم اسعدی 5980 تحلیل فقر در فضای شهری مریم اسعدی 6035 شهر سازی و ترافيک مریم اسعدی 4391 مدرنیزم در شهر سازی مریم اسعدی 7663 بازارها مریم اسعدی 2538 بررسی بازار در شهر سازی محسن سورگی 3626 GIS یا سیستم اطلاعات جغرافیای چیست ؟ مریم اسعدی 11531 بازآرایی میدان­های شهری سيما هاشمي­نيا 6737 شهر چیست؟ انواع شهرها و ویژگیهای آنها کدامند؟ memary.blogsky.com 8118 منظور از برنامه ریزی شهری و منطقه ای محسن سورگی 12027 توسعه شهر نشيني و پيامد هاي آن( با تكيه بر مورد ايران) Hamkelasy 4007 بررسي تحولات قيمت زمين در مناطق مختلف شهر تهران مهدی سورگی 2143 حقوق شهري و قوانين شهرسازي مهدی سورگی 5941 سيرتحول تهيه طرحهاي توسعه شهري در جهان و ايران دكتررضااحمديان 4325 شهرها و جهاني شدن نارسیس سهرابی 7703 معرفی سایت های علمی رشته شهرسازی محسن سورگی 7675 ساختار شبکه هاي ارتباطي در شهر محسن سورگی 4376 مشکلات عمده شهرهاي جديد به لحاظ طراحي و ساخت،اجرا و سکو محسن سورگی 4178 برتري شهرهاي جديد بر شهرهاي سنتي محسن سورگی 3472   << شروع < قبلي 1 2 بعدي > پايان >> نتايج 1 - 50 از 73 امکانات جدید سایت ارسال مقاله برای همکلاسی منابع کارشناسی ارشد - دروس و ضرایب منابع کارشناسی ارشد - منابع مطالعاتی پرسش و پاسخ لینک باکس مقالات عمران تبادل لینک تبلیغات در پایگاه همکلاسی آدرس وب سایت دانشگاه‌های ایران فروشگاه همکلاسی اخبار همکلاسی دوستان همکلاسی اطلاع رسانی کنفرانس‌ها فروشگاه همکلاسی همایش سازگاری با کم آبی 40,000 ریال بيل مكانيكي غول پيكر حفار معدن (The big excavator) 40,000 ریال کارون 3 - طراحی و نصب تجهیزات ابزار دقیق(ب) 40,000 ریال اولین همایش ملی مسیلها (کالها) 40,000 ریال اولین همایش ملی عمران شهری 40,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 = 52 )
 ORDER BY menuid DESC
LIMIT 1
3
DELETE FROM jos_session
 WHERE (
 ( time < '1265728240' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265728240' )
 AND guest = 1
 AND userid = 0
 )
4
SELECT session_id
 FROM jos_session
 WHERE session_id = 'ac78cb9ed9dcb6bd056a656295a8539c'
5
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'ac78cb9ed9dcb6bd056a656295a8539c','1265729140','','0','1' )
6
SELECT *
 FROM jos_menu
 WHERE id = 52
7
SELECT *
 FROM jos_categories
 WHERE id = '34'
8
SELECT *
 FROM jos_sections
 WHERE id = '6'
9
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-02-09 18:55' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-02-09 18:55' )
 AND b.access <= 0
 WHERE c.section = '6'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
10
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 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.catid = 34
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-02-09 18:55' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-02-09 18:55' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
11
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 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.catid = 34
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-02-09 18:55' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-02-09 18:55' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 50
12
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'
13
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 = 52 )
 ORDER BY ordering
14
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
15
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
17
SELECT guest, usertype
 FROM jos_session
18
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 0
19
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=2 )
20
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 24
21
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )
22
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 29
23
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
24
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'
25
SELECT params
 FROM jos_mambots
 WHERE element = 'sociotag'
 AND folder = 'content'
26
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
27
SELECT *
 FROM jos_mambots
 WHERE id = '25'
28
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=1 )
29
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 25
30
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )
31
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 29
32
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'left menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
33
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
34
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=428'
35
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=637'
36
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);
37
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'
38
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
39
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
40
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
41
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
42
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
43
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=7 
OR pc.category_id=8 
OR pc.category_id=9 
) 
 WHERE p.product_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
44
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='C12'
45
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='69' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
46
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`='69'
47
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=0
48
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='69'
49
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='69' AND (start_date<='1265729141' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
50
SELECT vendor_id FROM jos_vm_product WHERE product_id='69'
51
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
52
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='69'
53
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='69' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC
54
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='69'
55
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='69' AND shopper_group_id='5'  ORDER BY price_quantity_start
56
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='69'
57
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
58
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='D17'
59
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='25' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
60
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`='25'
61
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='25'
62
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='25' AND (start_date<='1265729141' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id
63
SELECT vendor_id FROM jos_vm_product WHERE product_id='25'
64
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='25'
65
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='25' 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='25'
67
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='25' 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='25'
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='F08'
71
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='86' 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`='86'
73
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='86'
74
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='86' AND (start_date<='1265729141' 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='86'
76
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='86'
77
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='86' 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='86'
79
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='86' 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='86'
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='C06'
83
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='63' 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`='63'
85
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='63'
86
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='63' AND (start_date<='1265729141' 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='63'
88
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='63'
89
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='63' 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='63'
91
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='63' 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='63'
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='C01'
95
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='58' 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`='58'
97
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='58'
98
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='58' AND (start_date<='1265729141' 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='58'
100
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='58'
101
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='58' 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='58'
103
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='58' 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='58'
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 *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=3 )
107
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 30
108
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
109
SELECT *
 FROM jos_mambots
 WHERE id = '25'
110
SELECT COUNT( id ) AS count_users
 FROM jos_users
111
SELECT COUNT( id ) AS count_items
 FROM jos_content
112
SELECT COUNT( id ) AS count_links
 FROM jos_weblinks
 WHERE published = 1
113
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
114
SELECT *
 FROM jos_mambots
 WHERE id = '25'
115
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
116
SELECT *
 FROM jos_mambots
 WHERE id = '25'
117
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'
118
SELECT *
 FROM jos_mambots
 WHERE id = '25'