| VENDORERRORCODE |
1064 |
| SQLSTATE |
42000 |
| SQL |
( select
events.id_events as id,
events.name
as label,
events.display
as link,
events.teaser
as snippet,
events.description
as altText,
'events' as type,
cast( 'exempt' as char ) as topics
from events
where ids_events = 1 AND
(
or or or or or or or or
)
group by events.id_events
)
union
( select
listings.id_listings as id,
listings.name
as label,
listings.display
as link,
listings.teaser
as snippet,
listings.description
as altText,
'listings' as type,
group_concat( cast( ltxxx.idt as char ) ) as topic
from listings
left outer join listings__topics ltxxx on listings.id_listings = ltxxx.id_listings
left outer join listings__attractions__link on listings.id_listings = listings__attractions__link.id_listings
left outer join attractions on listings__attractions__link.id_attractions = attractions.id_attractions
left outer join listings__businesses__link on listings.id_listings = listings__businesses__link.id_listings
left outer join businesses on listings__businesses__link.id_businesses = businesses.id_businesses
left outer join listings__conference_facilities__link on listings.id_listings = listings__conference_facilities__link.id_listings
left outer join conference_facilities on listings__conference_facilities__link.id_conference_facilities = conference_facilities.id_conference_facilities
left outer join listings__coupon__link on listings.id_listings = listings__coupon__link.id_listings
left outer join coupon on listings__coupon__link.id_coupon = coupon.id_coupon
left outer join listings__dining__link on listings.id_listings = listings__dining__link.id_listings
left outer join dining on listings__dining__link.id_dining = dining.id_dining
left outer join listings__lodging__link on listings.id_listings = listings__lodging__link.id_listings
left outer join lodging on listings__lodging__link.id_lodging = lodging.id_lodging
left outer join listings__press_releases__link on listings.id_listings = listings__press_releases__link.id_listings
left outer join press_releases on listings__press_releases__link.id_press_releases = press_releases.id_press_releases
where ids_listings = 1 AND
(
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
or
)
group by listings.id_listings
)
union
( select
pages.id_pages as id,
pages.title
as label,
pages.display
as link,
pages.meta_description
as snippet,
pages.intro_text
as altText,
'pages' as type,
cast( 'exempt' as char ) as topics
from pages
left outer join pages__page_sections__link on pages.id_pages = pages__page_sections__link.id_pages
left outer join page_sections on pages__page_sections__link.id_page_sections = page_sections.id_page_sections
where ids_pages = 1 AND
(
or
or
or
or
or
or
or
or
or
)
group by pages.id_pages
)
order by label
|
| DATASOURCE |
abilenevisitors |
|