|
|
| |
- About us
No valid database connection Unknown column 'u.name' in 'order clause' SQL=SELECT a.id, a.title, a.metakey, a.modified, CASE WHEN strcmp(a.created,a.publish_up)<0 THEN a.publish_up ELSE a.created END as `created`, a.sectionid,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as catslug
FROM nex_content AS a,nex_categories AS c
WHERE a.catid=(2)
AND a.catid=c.id
AND a.state='1'
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-20 08:43:33' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-20 08:43:33' )
AND a.access<='0'
ORDER BY a.created_by_alias DESC, u.name DESC
- Technology & Product
- Site Reference
- Public News
- Contact us
- Help
|
|
|
|