|
|
Log in | Sign up | Guest account |
|
{{Portal::Render::Engine::sqlcall - Bad SQL statement: "
SELECT
`sportal`.getTimeAgo(I.dateFound) AS timeAgo,
I.url, I.title, I.summaryMatch,
IF(length(S.homepage)>0.5,CONCAT('',S.sourceDisplayName,''),S.sourceDisplayName),
C.catUrlName, C.id, C.catName
FROM
np.categories AS C,
np.itemcategoryjunc AS J
JOIN np.items AS I ON I.id=J.item,
np.sources AS S
WHERE
J.category= AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.dateMatch)) < 5
ORDER BY J.item DESC
LIMIT 0,3
" : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.da' at line 23 }}
|
{{Portal::Render::Engine::sqlcall - Bad SQL statement: "
SELECT
`sportal`.getTimeAgo(I.dateFound) AS timeAgo,
I.url, I.title, I.summaryMatch,
IF(length(S.homepage)>0.5,CONCAT('',S.sourceDisplayName,''),S.sourceDisplayName),
C.catUrlName, C.id, C.catName
FROM
np.categories AS C,
np.itemcategoryjunc AS J
JOIN np.items AS I ON I.id=J.item,
np.sources AS S
WHERE
J.category= AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.dateMatch)) < 5
ORDER BY J.item DESC
LIMIT 9,16
" : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.da' at line 23 }}
|
{{Portal::Render::Engine::sqlcall - Bad SQL statement: "
SELECT
`sportal`.getTimeAgo(I.dateFound) AS timeAgo,
I.url, I.title, I.summaryMatch,
IF(length(S.homepage)>0.5,CONCAT('',S.sourceDisplayName,''),S.sourceDisplayName),
C.catUrlName, C.id, C.catName
FROM
np.categories AS C,
np.itemcategoryjunc AS J
JOIN np.items AS I ON I.id=J.item,
np.sources AS S
WHERE
J.category= AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.dateMatch)) < 5
ORDER BY J.item DESC
LIMIT 25,16
" : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.da' at line 23 }}
|
|
|
{{Portal::Render::Engine::sqlcall - Bad SQL statement: "
SELECT
`sportal`.getTimeAgo(I.dateFound) AS timeAgo,
I.url, I.title, I.summaryMatch,
IF(length(S.homepage)>0.5,CONCAT('',S.sourceDisplayName,''),S.sourceDisplayName),
C.catUrlName, C.id, C.catName
FROM
np.categories AS C,
np.itemcategoryjunc AS J
JOIN np.items AS I ON I.id=J.item,
np.sources AS S
WHERE
J.category= AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.dateMatch)) < 5
ORDER BY J.item DESC
LIMIT 3,3
" : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.da' at line 23 }}
|
{{Portal::Render::Engine::sqlcall - Bad SQL statement: "
SELECT
`sportal`.getTimeAgo(I.dateFound) AS timeAgo,
I.url, I.title, I.summaryMatch,
IF(length(S.homepage)>0.5,CONCAT('',S.sourceDisplayName,''),S.sourceDisplayName),
C.catUrlName, C.id, C.catName
FROM
np.categories AS C,
np.itemcategoryjunc AS J
JOIN np.items AS I ON I.id=J.item,
np.sources AS S
WHERE
J.category= AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.dateMatch)) < 5
ORDER BY J.item DESC
LIMIT 6,3
" : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND J.category=C.id AND I.source=S.id AND ABS(TIMESTAMPDIFF(DAY,I.dateFound,I.da' at line 23 }}
|
||