A Database Error Occurred

Error Number: 1064

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 store_categories.category_url = ? AND store_items.`status` = '1' ORDER ...' at line 24

SELECT store_items.*, store_category_assign.parent_category_id, store_category_assign.category_id, store_category_assign.item_id, store_category_assign.filter_id, store_parent_categories.parent_category_title, store_parent_categories.parent_category_url, store_categories.category_title, store_categories.category_url, item_brand_options.brand_title, item_brand_options.brand_url, navigation_menu.navigation_url, filters.filter_title, filters.filter_url FROM store_category_assign INNER JOIN store_items ON store_category_assign.item_id = store_items.id INNER JOIN store_parent_categories ON store_category_assign.parent_category_id = store_parent_categories.id INNER JOIN store_categories ON store_category_assign.category_id = store_categories.id INNER JOIN item_brand_options ON store_items.brand_id = item_brand_options.id INNER JOIN navigation_menu_assign ON store_category_assign.parent_category_id = navigation_menu_assign.parent_cat_id INNER JOIN navigation_menu ON navigation_menu_assign.nav_id = navigation_menu.id INNER JOIN filters ON store_category_assign.filter_id = filters.id WHERE store_parent_categories.parent_category_url = ? AND store_categories.category_url = ? AND store_items.`status` = '1' ORDER BY store_items.product_type ASC, store_items.desktop_picture DESC

Filename: modules/all_categories/controllers/All_categories.php

Line Number: 233