MySQL 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 'and p.language = 'bn' and c.language = 'bn' and b.language='bn' and m.langua...' at line 14 | SQL: select p.*,c.category_name,b.brand_name,m.model_name,bt.bodytype_name,tm.transmission_name,dt.drivetype_name,tad.type_of_ad_name,ct.condition_type_name,cs.change_ad_status_name,mp.membership_plan_name,mp.membership_plan_key,mp.membership_plan_order
from al_product p
left join al_category c on c.category_id = p.category_id or p.category_id = c.category_sl
left join al_brand b on b.brand_id = p.brand_id or p.brand_id = b.brand_sl
left join al_model m on m.model_id = p.model_id or p.model_id = m.model_sl
left join al_bodytype bt on bt.bodytype_id = p.bodytype_id or p.bodytype_id = bt.bodytype_sl
left join al_transmission tm on tm.transmission_id = p.transmission_type_id or tm.transmission_sl = p.transmission_type_id
left join al_drivetype dt on dt.drivetype_id = p.drivetype_id or p.drivetype_id = dt.drivetype_sl
left join al_type_of_ad tad on tad.type_of_ad_id = p.type_of_ad_id or p.type_of_ad_id = tad.type_of_ad_sl
left join al_condition_type ct on ct.condition_type_id = p.condition_type_id or p.condition_type_id = ct.condition_type_id
left join al_change_ad_status cs on cs.change_ad_status_id =p.product_status or cs.change_ad_status_sl = p.product_status
left join al_membership_plan mp on 1=1
left join al_user_membership_plan um on um.membership_plan_id = mp.membership_plan_id or um.membership_plan_id = mp.membership_plan_sl
where p.product_id= and p.language = 'bn' and c.language = 'bn' and b.language='bn' and m.language='bn' and bt.language = 'bn' and tm.language ='bn' and dt.language = 'bn' and tad.language = 'bn' and ct.language = 'bn' and cs.language = 'bn' and mp.language = 'bn'
and p.product_status=1 and um.admin_gate=1 and um.sup_admin_gate=1 and p.admin_gate=1 and p.sup_admin_gate=1 and um.user_id = p.create_by group by p.product_id