: SELECT * FROM products LEFT OUTER JOIN product_companies ON products.product_company_id = product_companies.product_company_id LEFT OUTER JOIN product_categories ON products.product_category_id = product_categories.product_category_id LEFT OUTER JOIN product_types ON products.product_type_id = product_types.product_type_id LEFT OUTER JOIN product_sers ON products.product_ser_id = product_sers.product_ser_id WHERE product_url='sky_watcher_maxview_90sp_ota' LIMIT 1;.