Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.IS_BUILD is_build, e.EVENTS_ID id, f.*, f.TITLE et, DATE_FORMAT( e.DATE_BEGIN, '%d.%m.%Y' ) DATE_BEGIN, DATE_FORMAT( e.DATE_END, '%d.%m.%Y' ) DATE_END, DATEDIFF(DATE_BEGIN, NOW()) is_started, o.ORGANIZERS_ID oid, fo.TITLE ot, p.PLACES_ID pid, fp.TITLE pt
FROM EVENTS e
JOIN FIRMS f ON f.FIRMS_ID=e.EVENTS_ID
LEFT JOIN EVENTS_THEMES ON EVENTS_THEMES.EVENTS_ID=e.EVENTS_ID
LEFT JOIN ORGANIZERS o ON e.ORGANIZERS_ID=o.ORGANIZERS_ID
LEFT JOIN FIRMS fo ON fo.FIRMS_ID=o.ORGANIZERS_ID
LEFT JOIN PLACES p ON e.PLACES_ID=p.PLACES_ID
LEFT JOIN FIRMS fp ON fp.FIRMS_ID=p.PLACES_ID WHERE (f.TYPE_OBJECT='expo' OR f.TYPE_OBJECT='confer') AND (REPLACE(REPLACE(REPLACE(REPLACE(f.TITLE,'"',''),''',''),' ',' '),'&','') LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(REPLACE(f.DESCRIPTION,'"',''),''',''),' ',' '),'&','') LIKE '%��������������������, ������������%' ) AND CAST('2024-04-19' AS datetime) <= e.DATE_BEGIN ORDER BY e.DATE_BEGIN LIMIT 15,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.ORGANIZERS_ID id, f.*, f.TITLE et
FROM ORGANIZERS e
JOIN FIRMS f ON f.FIRMS_ID=e.ORGANIZERS_ID WHERE 1=1 AND (REPLACE(REPLACE(REPLACE(REPLACE(f.TITLE,'"',''),''',''),' ',' ') ,'&','')LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(REPLACE(f.DESCRIPTION,'"',''),''',''),' ',' '),'&','') LIKE '%��������������������, ������������%' ) ORDER BY f.TITLE LIMIT 14,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS f.FIRMS_ID id, f.*, f.TITLE et
FROM FIRMS f WHERE f.TYPE_OBJECT='service_comp' AND (REPLACE(REPLACE(REPLACE(REPLACE(f.TITLE,'"',''),''',''),' ',' '),'&','') LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(REPLACE(f.DESCRIPTION,'"',''),''',''),' ',' '),'&','') LIKE '%��������������������, ������������%' ) ORDER BY f.TITLE LIMIT 13,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.PLACES_ID , f.*, f.TITLE et
FROM PLACES e
JOIN FIRMS f ON f.FIRMS_ID=e.PLACES_ID WHERE 1=1 AND (REPLACE(REPLACE(REPLACE(f.TITLE,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(f.DESCRIPTION,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' ) ORDER BY f.TITLE LIMIT 12,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.*, REGIONS.TITLE rt, OTRASL.TITLE ot, FIRMS.TITLE ft, TOWNS.TITLE tt FROM TENDER e
LEFT JOIN OTRASL ON OTRASL.OTRASL_ID=e.OTRASL_ID
LEFT JOIN REGIONS ON REGIONS.REGIONS_ID=e.REGIONS_ID
LEFT JOIN TOWNS ON e.TOWNS_ID=TOWNS.TOWNS_ID
LEFT JOIN FIRMS ON FIRMS.FIRMS_ID=e.FIRMS_ID WHERE e.PUBLICATION=1 AND e.DATE_END >= CAST('2024-04-19' AS datetime) AND (REPLACE(REPLACE(REPLACE(e.TITLE,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(e.DESCRIPTION,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' )ORDER BY DATE_END LIMIT 11,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.*, REGIONS.TITLE rt, TOWNS.TITLE tt, SUBJECT.TITLE st, FIRMS.TITLE ft FROM VACANCY e
LEFT JOIN SUBJECT ON SUBJECT.SUBJECT_ID=e.SUBJECT_ID
LEFT JOIN REGIONS ON REGIONS.REGIONS_ID=e.REGIONS_ID
LEFT JOIN TOWNS ON TOWNS.TOWNS_ID=e.TOWNS_ID
LEFT JOIN FIRMS ON FIRMS.FIRMS_ID=e.FIRMS_ID WHERE e.PUBLICATION=1 AND (REPLACE(REPLACE(REPLACE(e.TITLE,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' OR REPLACE(REPLACE(REPLACE(e.DESCRIPTION,'"',''),''',''),' ',' ') LIKE '%��������������������, ������������%' ) ORDER BY DATE DESC, e.VACANCY_ID DESC LIMIT 10,15 Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SELECT DISTINCT SQL_CALC_FOUND_ROWS e.NEWS_FIRM_ID, e.TITLE, e.NEWS_DATE, e.ANNOUNCE, e.FIRMS_ID, FIRMS.TITLE ft FROM NEWS_FIRM e
LEFT JOIN FIRMS ON FIRMS.FIRMS_ID=e.FIRMS_ID
WHERE e.STATUS='pub' AND e.PUBLICATION=1 AND (e.TITLE LIKE '%��������������������, ������������%' OR e.ANNOUNCE LIKE '%��������������������, ������������%') ORDER BY NEWS_DATE DESC LIMIT 9,15
Поиск выставок - Выставочный портал GeneralExpo.ru