| Message: | MySQL Query fail:
(SELECT
'categories' AS sqltype,
t1.id AS id, t1.urltag AS urltag, t1.weight AS weight, t1.title AS title,
t1.description AS description, t1.tags AS tags, t1.status AS status, t1.sponsor AS sponsor,
t1.niche AS niche, t1.profit AS profit, t1.signup AS signup, t1.linking AS linking,
t1.timestamp AS timestamp, '' AS pagetitle, '' AS content, '' AS article_pattern,
'' AS title_pattern, '' AS link_pattern, '' AS description_pattern, '' AS cache_timeout,
'' AS front, '' AS partner_from, '' AS partner_to, '' AS partner_text,
'' AS you_from, '' AS you_to, '' AS you_text, '' AS you_alt,
'' AS last_check, '' AS last_check_timestamp, '' AS url, '' AS img,
'' AS html, '' AS banner_group
FROM rcams_mf_final_categories AS t1)
UNION
(SELECT
'pages',
t2.id, t2.urltag, t2.weight, t2.title,
'', '', t2.status, '',
'', '', '', '',
t2.timestamp, t2.pagetitle, t2.content, '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', ''
FROM rcams_mf_final_staticpages AS t2)
UNION
(SELECT
'feeds',
t3.id, t3.urltag, t3.weight, t3.title,
'', '', t3.status, '',
'', '', '', '',
t3.timestamp, t3.pagetitle, '', t3.article_pattern,
t3.title_pattern, t3.link_pattern, t3.description_pattern, t3.cache_timeout,
t3.front, '', '', '',
'', '', '', '',
'', '', t3.url, '',
'', ''
FROM rcams_mf_final_feeds AS t3)
UNION
(SELECT
'links',
t4.id, '', t4.id, '',
'', '', '', '',
'', '', '', '',
t4.timestamp, '', '', '',
'', '', '', '',
'', t4.partner_from, t4.partner_to, t4.partner_text,
t4.you_from, t4.you_to, t4.you_text, t4.you_alt,
t4.last_check, t4.last_check_timestamp, '', '',
'', ''
FROM rcams_mf_final_linkexchanges AS t4
WHERE status = 'enabled' AND (last_check = 0 OR last_check = 1) AND (you_from = 'ALL' OR you_from = 'index'))
UNION
(SELECT
'banners',
t6.id, '', t6.id, t6.title,
'', '', t6.status, '',
'', '', '', '',
t6.timestamp, '', '', '',
'', '', '', '',
'', '', '', '',
'', '', '', '',
'', '', t6.url, t6.img,
t6.html, t5.name
FROM rcams_mf_final_bannerg AS t5
LEFT JOIN
(SELECT * FROM rcams_mf_final_bannerd WHERE status = 'enabled' ORDER BY RAND()) AS t6
ON t5.id = t6.groupid
GROUP BY t5.id)
UNION
(SELECT
'linkgroups',
t7.id, '', t7.id, t7.title,
'', '', '', '',
'', '', '', '',
t8.timestamp, '', '', '',
'', '', '', '',
'', t8.partner_from, t8.partner_to, t8.partner_text,
t8.you_from, t8.you_to, t8.you_text, t8.you_alt,
t8.last_check, t8.last_check_timestamp, '', '',
'', ''
FROM rcams_mf_final_linkgroups AS t7
JOIN rcams_mf_final_linkexchanges AS t8
WHERE t7.status = 'enabled' AND t8.status = 'enabled' AND t8.last_check NOT IN ('2', '3', '6') AND t8.you_from = CONCAT('LINKGROUP', t7.id))
ORDER BY weight ASC
|
