1
SELECT template FROM jos_templates_menu WHERE client_id='0' AND menuid='0'--------------------------------------------------------------------------------2
DELETE FROM jos_session
WHERE (time < 1152522984)--------------------------------------------------------------------------------3
SELECT * FROM jos_session WHERE session_id='86934ef6c8070663b4105acce9ea91cf'--------------------------------------------------------------------------------4
UPDATE jos_session SET `time`='1152523884',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='86934ef6c8070663b4105acce9ea91cf'--------------------------------------------------------------------------------5
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM jos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering--------------------------------------------------------------------------------6
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM jos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering--------------------------------------------------------------------------------7
SELECT access FROM jos_menu WHERE link like 'index.php?option=com_autobb%'--------------------------------------------------------------------------------8
SELECT * FROM jos_menu WHERE id='0'--------------------------------------------------------------------------------9
SELECT * FROM jos_autobb_config WHERE id='1'--------------------------------------------------------------------------------10
SELECT count(a.id)
FROM jos_autobb_messages AS a
LEFT JOIN jos_autobb_photos AS p
ON a.id=p.msgid
LEFT JOIN jos_autobb_vendors AS v
ON a.vendor=v.id
LEFT JOIN jos_autobb_models AS m
ON a.model=m.id
LEFT JOIN jos_autobb_colors AS c
ON a.color=c.id
LEFT JOIN jos_autobb_currency AS cur
ON a.currency=cur.id
WHERE a.published=1 AND a.expirationDate>=NOW()
GROUP BY a.id--------------------------------------------------------------------------------11
SELECT a.*, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,
count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle,
cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.createDate, '%a, %d %b %Y %T GMT') as rfcDate
FROM jos_autobb_messages AS a
LEFT JOIN jos_autobb_photos AS p
ON a.id=p.msgid
LEFT JOIN jos_autobb_vendors AS v
ON a.vendor=v.id
LEFT JOIN jos_autobb_models AS m
ON a.model=m.id
LEFT JOIN jos_autobb_colors AS c
ON a.color=c.id
LEFT JOIN jos_autobb_currency AS cur
ON a.currency=cur.id
WHERE a.published=1 AND a.expirationDate>=NOW()
GROUP BY a.id
ORDER BY a.sticked DESC, a.ordering ASC, a.createDate DESC
LIMIT 0, 10--------------------------------------------------------------------------------12
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m, jos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '0' OR mm.menuid = '0')
ORDER BY ordering--------------------------------------------------------------------------------13
SELECT a.id
FROM jos_components AS a
WHERE a.name = 'Syndicate'--------------------------------------------------------------------------------14
SELECT * FROM jos_components WHERE id='17'--------------------------------------------------------------------------------15
SELECT *
FROM jos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1--------------------------------------------------------------------------------16
SELECT id, name, link, parent, type
FROM jos_menu
WHERE published='1'
ORDER BY parent, ordering--------------------------------------------------------------------------------17
SELECT m.* FROM jos_menu AS m
WHERE menutype='topmenu' AND published='1' AND parent='0'
ORDER BY ordering--------------------------------------------------------------------------------18
SELECT a.id
FROM jos_content AS a
INNER JOIN jos_categories AS b ON b.id = a.catid
WHERE a.state = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2006-07-10 13:31:24')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2006-07-10 13:31:24')
AND catid='3'
ORDER BY a.ordering--------------------------------------------------------------------------------19
SELECT * FROM jos_content WHERE id='2'--------------------------------------------------------------------------------20
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM jos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering--------------------------------------------------------------------------------21
SELECT id FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'--------------------------------------------------------------------------------22
SELECT * FROM jos_mambots WHERE id='16'--------------------------------------------------------------------------------23
SELECT m.id
FROM jos_content AS i
LEFT JOIN jos_sections AS s ON i.sectionid=s.id
LEFT JOIN jos_menu AS m ON m.componentid=s.id
WHERE m.type='content_section' AND m.published='1' AND i.id=2--------------------------------------------------------------------------------24
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent,ordering--------------------------------------------------------------------------------25
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1'
ORDER BY parent,ordering--------------------------------------------------------------------------------26
SELECT count(*) AS numrows FROM jos_banner WHERE showBanner=1--------------------------------------------------------------------------------27
SELECT * FROM jos_banner WHERE showBanner=1
LIMIT 1,1--------------------------------------------------------------------------------28
UPDATE jos_banner SET impmade=impmade+1 WHERE bid='2'
Вот ошибки, плиз помогите надеюсь на вашу помощь
