$sql = "SELECT manufacturers_model, products_name, products_price, products_image, products_info FROM products_to_categories pc JOIN products p ON p.products_id = pc.products_id JOIN JOIN products_description pd ON p.products_id = pd.products_id WHERE p.products_status = 1 AND manufacturers_model > '' " . $where . " ORDER BY p.manufacturers_model LIMIT 0,50";