Wyniki

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 c.campsite_country='7' 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.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.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