SELECT
*
FROM
news n,
news_categories c,
news_to_news_categories nc
LEFT JOIN
users
ON
(users.users_id = n.news_authors_id)
WHERE
n.news_id = nc.news_id
AND
c.news_categories_id = nc.news_categories_id
AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2MySQL Error: Unknown column 'n.news_authors_id' in 'on clause'
Script : /home/sciinn/public_html/lib/dbase.class.php Linenumber : 226 Variables : this = Object , query = SELECT * FROM news n, news_categories c, news_to_news_categories nc LEFT JOIN users ON (users.users_id = n.news_authors_id) WHERE n.news_id = nc.news_id AND c.news_categories_id = nc.news_categories_id AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2 , show = , time = , transaction = , error_text =
SELECT
*
FROM
news n,
news_categories c,
news_to_news_categories nc
LEFT JOIN
users
ON
(users.users_id = n.news_authors_id)
WHERE
n.news_id = nc.news_id
AND
c.news_categories_id = nc.news_categories_id
AND n.news_status IN ('3') AND nc.news_categories_id = '1' AND n.news_publication_date <= '2010-09-04' AND n.news_expiry_date > '2010-09-04' GROUP BY n.news_id ORDER BY news_publication_date DESC LIMIT 0, 2MySQL Error: Unknown column 'n.news_authors_id' in 'on clause'
,
|
|
Ontwerp en uitvoering © 2004 Projectie Productions. |
Welkom op de website van SCI-INNStichting SCI-INN 4891 CP RIJSBERGEN Telefoon: 076-596 32 23 Contactpersonen: Carla Meek en Peter Kuijpers Bereikbaar alle werkdagen na 13.00 uur
Stichting Sociaal Cultureel Instituut Indonesië - Nederland is opgericht op 9 juni 1972 en is ingeschreven bij de KvK onder nummer 41150284. Wilt u de SCI-INN steunen dan kunt u uw donatie storten op onze rekening: 32.05.61.747.
In verband met tijdelijke onderbezetting kunnen enkele pagina's niet actueel zijn. Deze welkomstpagina bevat echter alle actuele gegevens. |