• Italian - Italy
  • English (United Kingdom)

Contacts Distributors International Network

International Network

No valid database connection Disk full (/var/tmp/#sql_4c3_0); waiting for someone to free some space... SQL=SELECT a.*,cc.description as catdesc, cc.title as category_title, cc.title as cattitle,s.description as secdesc, s.title as sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",cc.id,cc.alias) ELSE cc.id END as catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END as secslug FROM jos_content AS a INNER JOIN jos_categories AS cc ON cc.id = a.catid INNER JOIN jos_sections AS s ON s.id = a.sectionid WHERE a.state = 1 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-10-21 01:21:41' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-10-21 01:21:41' ) AND a.access <= 0 AND a.catid IN( 56 ) ORDER BY created desc LIMIT 10