| |
Home
precisionalarmco.com | Monday, 20 May 2024 |
|
|
| |
Incorrect DATETIME value: \'0000-00-00 00:00:00\' SQL=SELECT ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count,\na.*, u.name AS author, u.usertype\nFROM mos_content AS a\nINNER JOIN mos_content_frontpage AS f ON f.content_id = a.id\nLEFT JOIN mos_users AS u ON u.id = a.created_by\nLEFT JOIN mos_content_rating AS v ON a.id = v.content_id\nWHERE a.state=\'1\'\n AND a.access <= \'0\'\n AND (publish_up = \'0000-00-00 00:00:00\' OR publish_up <= NOW())\n AND (publish_down = \'0000-00-00 00:00:00\' OR publish_down >= NOW())\nORDER BY f.ordering, a.ordering ASC, a.catid, a.sectionid LIMIT 6
No items to display |
|
| |
|
| |
|
|
| |
|
|
|
Miro International Pty Ltd. © 2000 - 2004 All rights reserved.
Mambo Open Source is Free Software released under the GNU/GPL License.
|
