I worked in a regional London-based firm with another small office elsewhere in the UK specialising in no win no fee compensation claims. The firm had many paralegals because Read more
My views and my articles and anything you can find on my website is my intellectual property: - If you would like to take any material from my website and post it on a third party's website you need to reference my website; - If you would like to quote me in a published document, you need to get my permission first. Please contact me if that's the case.
SELECT folder ASTYPE, element AS name, params FROM jos_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT template FROM jos_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =216) ORDERBY menuid DESC LIMIT0,1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title ASSECTION,CASEWHENCHAR_LENGTH(a.alias)THEN CONCAT_WS(":", a.id, a.alias)ELSE a.id ENDAS slug,CASEWHENCHAR_LENGTH(cc.alias)THEN CONCAT_WS(":", cc.id, cc.alias)ELSE cc.id ENDAS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access FROM jos_content AS a LEFTJOIN jos_categories AS cc ON cc.id = a.catid LEFTJOIN jos_sections AS s ON s.id = cc.SECTION AND s.scope ="content" LEFTJOIN jos_users AS u ON u.id = a.created_by LEFTJOIN jos_groups AS g ON a.access = g.id WHERE a.id =93 AND(( a.created_by =0)OR( a.state =1 AND( a.publish_up ='0000-00-00 00:00:00'OR a.publish_up <='2024-04-19 23:40:52') AND( a.publish_down ='0000-00-00 00:00:00'OR a.publish_down >='2024-04-19 23:40:52'))OR( a.state =-1))
UPDATE jos_content SET hits =( hits +1) WHERE id='93'
SELECT`value`,`name` FROM jos_urcomment_config WHERE`name`='allConfig'OR`name`='themeConfig'
SELECTCOUNT(`value`)ASCOUNT,SUM(`value`)ASSUM FROM jos_urcomment_rating WHERE`contentid`='93'
SELECT`value`,`name` FROM jos_urcomment_config WHERE`name`='allConfig'OR`name`='themeConfig'
SELECT`hits` FROM jos_content WHERE`id`='93'
SELECT`value`,`name` FROM jos_urcomment_config WHERE`name`='allConfig'OR`name`='themeConfig'
SELECT* FROM jos_urcomment WHERE contentid='93' AND published='1' AND parentid='-1' ORDERBYDATEDESC LIMIT0,10
SELECT* FROM jos_urcomment WHERE contentid='93' AND published='1'
SELECT`value`,`name` FROM jos_urcomment_config WHERE`name`='allConfig'OR`name`='themeConfig'
SELECT* FROM jos_urcomment WHERE contentid='93' AND published='1' AND parentid='-1' ORDERBY id DESC
SELECT id, title, module,POSITION, content, showtitle, control, params FROM jos_modules AS m LEFTJOIN 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 =216OR mm.menuid =0) ORDERBYPOSITION, ordering
SELECT guest, usertype, client_id FROM jos_session WHERE client_id =0