SELECT
									c.active AS active,
									c.id AS catalogue_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,
									c.es_d1 AS d1,
									c.d1 AS en_name,
				 					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,
			 						c.note,
									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
								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 = 214076
    						AND
    							c.active = 1  AND ((c.manufacturer IN ('Crown', 'RT Off-Road') OR c.in_crown_line = '1') OR (c.manufacturer IN ('Bestop', 'Bushwacker', 'Mattouno', 'Valvoline', 'Rustys', 'K2', 'Suntop'))) AND (c.price_1 > 0 OR c.manufacturer IN ('Bestop', 'Bushwacker', 'Mattouno', 'Bilstein', 'Valvoline', 'Rustys', 'K2', 'Suntop'))
	    					LIMIT 1