| MODx encountered the following error while attempting to parse the requested resource: | ||
| « Execution of a query to the database failed - Unknown column 'sc.createdon' in 'order clause' » | ||
| SQL: SELECT sc.id,sc.pagetitle,TA2.ct as pageview,sc.title,editedon,wu.username FROM ( SELECT sc0.id,sc0.pagetitle,os.searchkey2,sc0.content, mg.gal_id,sc0.introtext,mg.title,sc0.isfolder, sc0.editedon,sc0.createdby FROM db_oc.modx_site_content sc0 INNER JOIN db_oc.modx_oc_t_site_content os ON(sc0.id = os.content_id) INNER JOIN db_oc.modx_maxigallery mg ON(os.content_id = mg.gal_id) WHERE sc0.parent = '233' AND os.content_type = '5' AND sc0.deleted = '0' AND sc0.published='1' AND sc0.hidemenu = '0' ) sc LEFT JOIN ( SELECT content_id,count(id) as ct FROM db_oc.modx_oc_t_point_additions WHERE content_type = '5' AND evaluation = '1' GROUP BY content_id ) TA2 ON (sc.id = TA2.content_id) LEFT JOIN db_oc.modx_web_users wu ON(wu.id=sc.createdby) WHERE sc.isfolder='0' GROUP BY sc.id ORDER BY sc.createdon desc LIMIT 0,3
[Copy SQL to ClipBoard] | ||
| Parser timing | ||
| MySQL: | 0.0755 s | (13 Requests) |
| PHP: | 0.1772 s | |
| Total: | 0.2526 s | |