کلیه مقالات پایگاه علمی همکلاسی تحت مجوز 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

119 queries executed

1
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering2
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 43 )
 ORDER BY menuid DESC
LIMIT 13
DELETE FROM jos_session
 WHERE (
 ( time < '1265676455' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265676455' )
 AND guest = 1
 AND userid = 0
 )4
SELECT *
 FROM jos_session
 WHERE session_id = '458635a5e9cdff0789c9ad6fb15a1cda'5
SELECT session_id
 FROM jos_session
 WHERE session_id = 'af23d23e479cd61125608732defea030'6
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'af23d23e479cd61125608732defea030','1265677355','','0','1' )7
SELECT *
 FROM jos_menu
 WHERE id = 438
SELECT *
 FROM jos_categories
 WHERE id = '16'9
SELECT *
 FROM jos_sections
 WHERE id = '6'10
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 04:32' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-02-09 04:32' )
 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.ordering11
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 = 16
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-02-09 04:32' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-02-09 04:32' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC12
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 = 16
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-02-09 04:32' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-02-09 04:32' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 5013
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'14
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 = 43 )
 ORDER BY ordering15
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering17
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering18
SELECT guest, usertype
 FROM jos_session19
SELECT DISTINCT a.username
 FROM jos_session AS a
 WHERE a.guest = 020
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=2 )21
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 2422
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )23
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 2924
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering25
SELECT *
 FROM jos_comment_setting
 WHERE id = '1'26
SELECT params
 FROM jos_mambots
 WHERE element = 'sociotag'
 AND folder = 'content'27
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'28
SELECT *
 FROM jos_mambots
 WHERE id = '25'29
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=1 )30
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 2531
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=4 )32
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 2933
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'left menu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering34
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 135
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=428'36
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=637'37
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);38
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'39
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =2940
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'41
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.lft42
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'43
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.lft44
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 545
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='C13'46
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='70' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id47
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`='70'48
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1 AND access=049
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='70'50
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='70' AND (start_date<='1265677356' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id51
SELECT vendor_id FROM jos_vm_product WHERE product_id='70'52
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'53
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='70'54
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='70' 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 DESC55
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='70'56
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='70' AND shopper_group_id='5'  ORDER BY price_quantity_start57
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='70'58
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` DESC59
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='E17'60
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='43' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id61
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`='43'62
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='43'63
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='43' AND (start_date<='1265677356' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id64
SELECT vendor_id FROM jos_vm_product WHERE product_id='43'65
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='43'66
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='43' AND shopper_group_id='5'  AND (('0' >= price_quantity_start AND '0' <= price_quantity_end)
                                OR (price_quantity_end='0') OR ('0' > price_quantity_end)) ORDER BY price_quantity_end DESC67
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='43'68
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='43' AND shopper_group_id='5'  ORDER BY price_quantity_start69
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='43'70
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` DESC71
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='E10'72
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_id73
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'74
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='36'75
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='36' AND (start_date<='1265677356' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id76
SELECT vendor_id FROM jos_vm_product WHERE product_id='36'77
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='36'78
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 DESC79
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='36'80
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_start81
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='36'82
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` DESC83
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='D25'84
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='80' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id85
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`='80'86
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='80'87
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='80' AND (start_date<='1265677356' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id88
SELECT vendor_id FROM jos_vm_product WHERE product_id='80'89
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='80'90
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='80' 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 DESC91
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='80'92
SELECT product_price, product_price_id, product_currency FROM jos_vm_product_price WHERE product_id='80' AND shopper_group_id='5'  ORDER BY price_quantity_start93
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='80'94
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` DESC95
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='C01'96
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_id97
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'98
SELECT  product_id, `product_name` FROM jos_vm_product WHERE product_id='58'99
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='58' AND (start_date<='1265677356' OR start_date=0) AND (end_date>='1265659560' OR end_date=0) AND product_discount_id=discount_id100
SELECT vendor_id FROM jos_vm_product WHERE product_id='58'101
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='58'102
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 DESC103
SELECT  product_id, `product_parent_id` FROM jos_vm_product WHERE product_id='58'104
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_start105
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='58'106
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` DESC107
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=3 )108
UPDATE jos_banner
 SET impmade = impmade + 1
 WHERE bid = 30109
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'110
SELECT *
 FROM jos_mambots
 WHERE id = '25'111
SELECT COUNT( id ) AS count_users
 FROM jos_users112
SELECT COUNT( id ) AS count_items
 FROM jos_content113
SELECT COUNT( id ) AS count_links
 FROM jos_weblinks
 WHERE published = 1114
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'115
SELECT *
 FROM jos_mambots
 WHERE id = '25'116
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'117
SELECT *
 FROM jos_mambots
 WHERE id = '25'118
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_ajaxvote' AND folder = 'content'119
SELECT *
 FROM jos_mambots
 WHERE id = '25'

فهرست مقالات

منوی سایت

افراد آنلاین

فرم ورود

فروشگاه تیتانیوم و نقرهفروشگاه زیورآلات پارسیان

امکانات جدید سایت

فروشگاه همکلاسی

تبلیغات

آمار سایت

پراکندگی جغرافیایی کاربران

RSS مقالات