SELECT *
FROM jos_session
WHERE session_id = 'ds96p5lv03adi0g1fbflilhlb0'
DELETE
FROM jos_session
WHERE ( TIME < '1734840341' )
SELECT *
FROM jos_session
WHERE session_id = 'ds96p5lv03adi0g1fbflilhlb0'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'ds96p5lv03adi0g1fbflilhlb0','1734841241','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM `jos_rsfirewall_configuration`
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0
ORDER BY menuid DESC
LIMIT 0, 1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND menuid = 0
ORDER BY menuid DESC
LIMIT 0, 1
SELECT `extension`, `file`, `type`
FROM `jos_rokcommon_configs`
ORDER BY `priority`
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.216.161.178' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.216.161.178' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`, `reason`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.216.161.178' OR `ip` LIKE '%*%')
AND `type`='0'
AND `published`='1'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.26'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='1.5.26'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
SELECT *
FROM jos_rsfirewall_hashes
WHERE `type`='protect'
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.216.161.178' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT `ip`
FROM jos_rsfirewall_lists
WHERE (`ip`='18.216.161.178' OR `ip` LIKE '%*%')
AND `type`='1'
AND `published`='1'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 180)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, parent_id, VALUE, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
SELECT id
FROM jos_k2_categories
WHERE published=1
AND trash=0
AND access<=0
SELECT *
FROM jos_k2_items
WHERE id=164
LIMIT 0, 1
SELECT *
FROM jos_k2_categories
WHERE id = '51'
SELECT tag.*
FROM jos_k2_tags AS tag
JOIN jos_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 164
ORDER BY xref.id ASC
SELECT *
FROM jos_k2_attachments
WHERE itemID=164
SELECT *
FROM jos_k2_rating
WHERE itemID = 164
SELECT *
FROM jos_users
WHERE id = '62'
SELECT id, gender, description, image, url, `group`, plugins
FROM jos_k2_users
WHERE userID=62
SELECT COUNT(*)
FROM jos_k2_comments
WHERE itemID=164
AND published=1
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.VALUE='62'
ORDER BY g.id
UPDATE jos_k2_items
SET hits = ( hits + 1 )
WHERE id='164'
SELECT *
FROM jos_jcomments_settings
SELECT COUNT(*)
FROM jos_jcomments AS c
WHERE c.object_id = 164
AND c.object_group = 'com_k2'
AND c.published = 1
SELECT *
FROM `jos_jcomments_objects`
WHERE `object_id` = '164'
AND `object_group` = 'com_k2'
AND `lang` = 'fa-IR'
SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
, c.email, c.homepage, c.DATE, c.DATE AS datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
, c.isgood, c.ispoor
, v.VALUE AS voted
, CASE WHEN c.parent = 0 THEN unix_timestamp(c.DATE) ELSE 0 END AS threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner
FROM jos_jcomments AS c
LEFT JOIN jos_jcomments_votes AS v
ON c.id = v.commentid
AND v.userid = 0
AND v.ip = '18.216.161.178'
WHERE c.object_id = 164
AND c.object_group = 'com_k2'
AND c.published = 1
ORDER BY c.parent, c.DATE DESC
SELECT *
FROM jos_k2_items
WHERE id != 164
AND catid=51
AND ordering > 11
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-22 04:20:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-22 04:20:41' )
AND access <= 0
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1
SELECT *
FROM jos_k2_items
WHERE id != 164
AND catid=51
AND ordering < 11
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-12-22 04:20:41' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-12-22 04:20:41' )
AND access <= 0
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1
SELECT params
FROM jos_components AS c
WHERE c.OPTION='com_widgetkit'
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 180 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
نظرات
واقعا عالیه , بینظیر
سه تا مطلب من مشکل داشتم
یکی آموزش روش AHP البته خیلی چیزهای اونا میدونم ولی با ماتریس مشکل دارم
دوم یکسری مقالات خارجی برای روش ایندکس اورلی
روش فازی که مثلا با چه دیدی از sum , and , or استفاده میکنیم
فید آر اس اس برای نظرات به این ارسال