1253

COLLATION 'utf8_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 INNER JOIN (SELECT ic.item_id FROM #__djc2_items_categories AS ic INNER JOIN #__djc2_categories AS c ON c.id=ic.category_id WHERE c.published = 1 AND c.access IN (1,1,5) AND ic.category_id IN (44)) as category_filter ON i.id = category_filter.item_id 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 WHERE (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-03-19 02:46:02') AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-03-19 02:46:02') AND ( LOWER(i.name) LIKE 'g%' COLLATE utf8_bin OR UPPER(i.name) LIKE 'g%' COLLATE utf8_bin ) AND i.published = 1 AND i.access IN (1,1,5) AND i.parent_id=0 ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc LIMIT 24

Go Back Home