1253

COLLATION 'utf8mb3_bin' is not valid for CHARACTER SET 'utf8mb4' SQL=SELECT distinct i.*, CASE WHEN (i.special_price > 0.0 AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name FROM #__djc2_items as i LEFT JOIN #__djc2_categories AS c ON c.id = i.cat_id LEFT JOIN #__djc2_producers AS p ON p.id = i.producer_id LEFT JOIN #__users AS ua ON ua.id = i.created_by LEFT JOIN #__djc2_countries AS countries ON countries.id = i.country LEFT JOIN #__djc2_countries_states AS states ON states.id = i.state INNER JOIN (select * from (select count(*) as c, item_id from ((select * from #__djc2_items_extra_fields_values_int where field_id=13 and value=22)) as f group by f.item_id) as filter_counter where filter_counter.c=1) as filters on filters.item_id = i.id WHERE c.published = 1 AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-03-28 19:05:20') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-03-28 19:05:20') AND i.producer_id = 4 AND ( LOWER(i.name) LIKE 'm%' COLLATE utf8_bin OR UPPER(i.name) LIKE 'm%' COLLATE utf8_bin ) AND i.published = 1 AND i.access IN (1,1,5) AND i.parent_id=0 ORDER BY i.created desc , i.ordering, c.ordering LIMIT 6

The Page you are looking for doesn't exist or an other error occurred.
Go back, or head over to the home page to choose a new direction.