SELECT folder ASTYPE, element AS name, params FROM j15_plugins WHERE published >=1 AND access <=0 ORDERBY ordering
SELECT`value`
FROM`j15_admintools_storage`
WHERE`key`='cparams'
SELECTMAX(TIME) FROM j15_vvcounter_logs
SELECT template FROM j15_templates_menu WHERE client_id =0 AND(menuid =0OR menuid =57) 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 j15_content AS a LEFTJOIN j15_categories AS cc ON cc.id = a.catid LEFTJOIN j15_sections AS s ON s.id = cc.SECTION AND s.scope ="content" LEFTJOIN j15_users AS u ON u.id = a.created_by LEFTJOIN j15_groups AS g ON a.access = g.id WHERE a.id =102 AND(( a.created_by =0)OR( a.state =1 AND( a.publish_up ='0000-00-00 00:00:00'OR a.publish_up <='2024-05-15 03:21:36') AND( a.publish_down ='0000-00-00 00:00:00'OR a.publish_down >='2024-05-15 03:21:36'))OR( a.state =-1))
UPDATE j15_content SET hits =( hits +1) WHERE id='102'