CLASS.DB OUTPUT:

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '@consciousinitiative.com != '', t1.name_conferences@consciousinitiative.com, ...' at line 6

CLASS.DB OUTPUT:

QUERY:

SELECT 
				t1.*,
				t1.id as product_id,
				t2.brand_name,
				t3.unit_name,
				IF(t1.name_conferences@consciousinitiative.com != '', t1.name_conferences@consciousinitiative.com, t1.name_en) as name,
				IF(t1.url_code_conferences@consciousinitiative.com != '', t1.url_code_conferences@consciousinitiative.com, t1.url_code_en) as url_code,
				IF(t1.description_conferences@consciousinitiative.com != '', t1.description_conferences@consciousinitiative.com, t1.description_en) as description,
				IF(t1.venue_conferences@consciousinitiative.com != '', t1.venue_conferences@consciousinitiative.com, t1.venue_en) as event_venue,
				IF(t1.schedule_conferences@consciousinitiative.com != '', t1.schedule_conferences@consciousinitiative.com, t1.schedule_en) as event_schedule,
				IF(t1.values_conferences@consciousinitiative.com != '', t1.values_conferences@consciousinitiative.com, t1.values_en) as event_values,
				IF(t1.benefits_conferences@consciousinitiative.com != '', t1.benefits_conferences@consciousinitiative.com, t1.benefits_en) as event_benefits,
				IF(t1.price_info_conferences@consciousinitiative.com != '', t1.price_info_conferences@consciousinitiative.com, t1.price_info_en) as price_info,
				(SELECT fk_category_id FROM mdl_shop_product_category WHERE fk_product_id = t1.id ORDER BY fk_category_id DESC LIMIT 1) as main_cat_id,
				(SELECT COUNT(*) FROM mdl_shop_product_files WHERE type='image' AND fk_product_id = t1.id LIMIT 1) as images_count FROM mdl_shop_products as t1
			LEFT JOIN mdl_shop_brands AS t2 ON t1.fk_brand_id = t2.id
			LEFT JOIN mdl_shop_units AS t3 ON t1.fk_unit_id = t3.id WHERE t1.id = '14' 
			AND t1.deleted = 0 AND t1.active = 1