Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor.
Query: SELECT DISTINCT cv.cid,nc.cName,nc.cUrl FROM categoryvalue cv LEFT JOIN newscategory nc ON (cv.cid=nc.cid) WHERE nc.cStatus = 'Enable' AND nc.cIsactive=1 ORDER BY corder ASC Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'drnishnt_19as.nc.corder' which is not in SELECT list; this is incompatible with DISTINCT
Archives
Error at 2025-09-21 20:28:51:
Query: SELECT DISTINCT year(pDateTime) as year FROM press WHERE pActive=1 AND pStatus='Enable' ORDER BY pDateTime DESC Error: Expression #1 of ORDER BY clause is not in SELECT list, references column 'drnishnt_19as.press.pDateTime' which is not in SELECT list; this is incompatible with DISTINCT
