An Error occured!SQLSTATE[HY000]: General error: 1271 Illegal mix of collations for operation 'UNION'
( select ''as tt_campsite_id, c.campsite_id, /*str_radius*/
c.campsite_name,
ifnull(c.campsite_bestplace,0) as campsite_bestplace,
ifnull(c.campsite_status,0) as campsite_status,
c.campsite_latlong,
co.country_value_pl as country_name,
cr.country_region_value_pl as region_name,
c.campsite_zip, c.campsite_phone, c.campsite_email, c.campsite_website, c.campsite_city,
c.campsite_country, c.campsite_region,c.campsite_street,
GROUP_CONCAT( cc.campsite_characteristic_id ) as defids
,
( select concat('[',
GROUP_CONCAT(
DISTINCT(
concat('{"id":"',
cc.campsite_characteristic_id,
'","title":"',
cc.campsite_characteristic_name_pl ,
'","icon": "',
cc.campsite_characteristic_type_icon,'"}'
)
)
)
,']') ) as char_defs,
(
select concat('[',
(select
GROUP_CONCAT(DISTINCT CONCAT('
{"image":"', ac.campsite_accommodation_type_icon ,'",
"id":"', ac.campsite_accommodation_type_id,'",
"pos":"', ac.sortposition,'",
"text":"', ac.campsite_accommodation_type_value_pl,'"}' ) )
from campsite_accommodations_combinations acc
inner join campsite_accommodation_type ac
on ac.campsite_accommodation_type_id = acc.campsite_accommodation_type_id
where acc.campsite_id=c.campsite_id
GROUP by acc.campsite_id )
,']') ) as json_accos,
( select concat('[', (select GROUP_CONCAT(DISTINCT CONCAT('{"provider":"',p.campsite_provider_name,
'", "provider_id":"',p.campsite_provider_id,
'", "provider_image":"', ifnull(p.campsite_provider_image,'') ,
'", "id":"', cpc.campsite_provider_combination_id ,
'","deeplink":"',
cpc.deeplink, '","premium":"',
(select count(*) from campsite_provider_premium cpp
where cpp.campsite_provider_id = cpc.campsite_provider_id
and cpp.campsite_id =c.campsite_id
),'"}' ) order by
(select count(*) from campsite_provider_premium cpp
where cpp.campsite_provider_id = cpc.campsite_provider_id
and cpp.campsite_id =c.campsite_id
) desc )
from campsite_provider p
inner join campsite_provider_combinations cpc
on cpc.campsite_provider_id = p.campsite_provider_id
inner join campsite_accommodations_combinations cac on
(cac.campsite_provider_id = p.campsite_provider_id and cac.campsite_id = cpc.campsite_id )
left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = cpc.campsite_id )
where cpc.campsite_id=c.campsite_id
and cpc.language='pl' and cpc.deeplink!=''
and ifnull(p.campsite_provider_status,1)<=1
and ifnull(p.campsite_provider_activ_pl,1)=1
and ifnull(s.campsite_provider_status_value,1)=1
) ,']') )
as provider_json,
ifnull(c.campsite_description_pl,'') as campsite_description,
c.campsite_stars
/*,
(
select GROUP_CONCAT(post_id) as posts from wp_postmeta WHERE meta_key='cb_campsite_id' and meta_value=c.campsite_id
) as post_ids */
from campsites c inner join campsite_characteristics_combinations ccc on ccc.campsite_id = c.campsite_id inner join campsite_characteristics cc on cc.campsite_characteristic_id=ccc.campsite_characteristic_id inner join country co on co.country_id = c.campsite_country inner join country_region cr on cr.country_region_id = c.campsite_region where (select count(*) from imagepool_images iip where iip.campsite_id = c.campsite_id and isnull(iip.deleted_date) ) >0 and (select count(*) from campsite_provider_combinations acc_main
inner join campsite_provider p on p.campsite_provider_id = acc_main.campsite_provider_id
left join campsite_provider_status s on ( s.campsite_provider_id = p.campsite_provider_id and s.campsite_id = acc_main.campsite_id )
where acc_main.campsite_id=c.campsite_id
and acc_main.campsite_provider_id='30/pl'
and acc_main.language='pl'
and ifnull(p.campsite_provider_activ_pl,1)=1
and ifnull(s.campsite_provider_status_value,1)=1
and acc_main.deeplink!='') >0 and c.campsite_online=1 and ifnull(c.campsite_online_pl,1)=1 group by c.campsite_id order by
ifnull(c.campsite_bestplace,0) desc,
-c.campsite_description_de DESC,
FIELD(c.campsite_status, '7') DESC,
(select count(*) from campsite_provider_combinations acc_main
where acc_main.campsite_id=c.campsite_id
and acc_main.campsite_provider_id='30/pl'
and acc_main.language='pl' and
acc_main.deeplink!='')
desc )
UNION
(
SELECT
t.tt_campsite_id,
t.campsite_id AS campsite_id,
t.name AS campsite_name,
0 AS campsite_bestplace,
1 AS campsite_status,
concat(t.latitude, ',', t.longitude) AS campsite_latlong,
t.country AS country_name,
t.region AS region_name,
'' AS campsite_zip,
'' AS campsite_phone,
'' AS campsite_email,
'' AS campsite_website,
t.city AS campsite_city,
t.country AS campsite_country,
t.region AS campsite_region,
t.address AS campsite_street,
'' AS defids,
'' AS char_defs,
'' AS json_accos,
'' AS provider_json,
'' AS campsite_description,
'' AS campsite_stars
FROM tradetracker_campsites t
where t.language = 'pl'
)limit 0,12