SELECT
									c.active AS active,
									c.id AS catalogue_id,
									c.note AS note,
									a.note AS application_note,
									a.id AS application_id,
									c.replace_part AS replace_part,
    							c.rbs_kit_code,
									c.is_kit,
									c.manufacturer AS manufacturer,
									c.weight AS weight,
									c.is_oversize,
									c.is_crown_kit,
									c.dimension_width AS dimension_width,
									c.dimension_height AS dimension_height,
									c.dimension_depth AS dimension_depth,
									c.show_price AS show_price,
									a.profile_type AS profile_type,
									a.feed_id AS feed_id,
									a.it_comments AS comments,
									c.it_d1 AS d1,
									c.d1 AS en_name,
									a.it_d2 AS d2,
									a.it_d3 AS d3,
									a.it_d4 AS d4,
									a.it_d5 AS d5,
			  					a.from_year AS from_year,
	  							a.to_year AS to_year,
									p.parent_id AS category_parent_id,
									p.it_order_dn2 AS order_dn2,
									p.it_order_dn3 AS order_dn3,
									p.it_order_dn4 AS order_dn4,
									p.it_order_dn5 AS order_dn5,
				 					c.youtube_1 AS youtube_1,
				 					c.youtube_2 AS youtube_2,
				 					c.attach AS attach,
				 					c.install_time_from,
			 						c.install_time_to,
			 						c.install_time_key,
									c.is_oversize,
									c.spinner_step,
									c.dci_lhd_rhd,
									c.dci_door,
			 						p.parent_id AS category_parent_id,
			 						p.id AS category_id,
			 						p.name AS category_name,
			 						p.slug AS category_slug,
			 						m.id AS model_id,
			 						m.slug AS model_slug,
			 						m.name AS model_name,
			 						b.slug AS brand_slug,
			 						b.name AS brand_name,
									rbs.gallery_path,
									rbs.pdf,
									rbs.is_universal,
									rbs.is_no_tuv,
		  						rbs.unit,
		  						rbs.ratio_to_unit,
									rbs.homologation_type,
									cpd.dir || '/800/' || cpd.file AS photo,
									cpd1.dir || '/800/' || cpd1.file AS kit_photo
	    					FROM
  	  						cg_catalogue c
    						INNER JOIN
    							cg_application a
    						ON
    							c.id = a.catalogue_id
	    					INNER JOIN
   								cg_part p
	   						ON
  	 							a.part_id = p.id
  	 						INNER JOIN
  	 							cg_model m
  	 						ON
  	 							a.model_id = m.id
  	 						INNER JOIN
									cg_brand b
								ON
									m.brand_id = b.id  	 	
								INNER JOIN
									rbs_categories cat
								ON
									a.category_id = cat.id
								LEFT JOIN
									rbs_parts rbs
								ON
									c.replace_part = rbs.code
								LEFT JOIN
									central_picture_database cpd
								ON
									cpd.rp = c.replace_part
								LEFT JOIN
									central_picture_database cpd1
								ON
									cpd1.rp = c.rbs_kit_code
   							WHERE
    							c.id = 227110
    						AND
    							c.active = 1
    						AND
    							a.model_id = 63
    						AND
    							cat.id = 527 AND ((c.manufacturer IN ('Crown', 'RT Off-Road') OR c.in_crown_line = '1') OR (c.manufacturer IN ('Bestop', 'Bushwacker', 'Mattouno', 'Bilstein'))) AND c.price_1 > 0
	    					LIMIT 1