query:select distinct v.id as id
		,vp.type as TYPE 
		,vp.tyre as tyre 
		,vp.sub_model as sub_model 
		, p.id as product_id 
		, p.name as product_name
		, c.producttype as producttype
		,c.category as category
		,p.brand as brand 
		,c.description as c_desc
		, pt.description as pt_desc
		, v.vehicletype as vehicletype
		, p.prod_id as prod_id
		, pe.Name as pt_emulate
		, ce.Name as c_emulate
		, v.make as v_make


	from 
		rbvehicle v		
		left join
		rbvehicle_product vp
		on  v.id = vp.vehicle_id
		left join  
		rbproduct p 
		on p.ID = vp.product_id		
		left join  
		rbcategory c
		on p.Category_ID = c.id
		left  join  
		rbproducttype pt
		on c.producttype = pt.producttype
		left  join  
		rbemulate ce
		on c.emulate_id = ce.id
		left  join  
		rbemulate pe
		on pt.emulate_id = pe.id

	where p.suppress <> 'Y'
		and   vp.suppress <> 'Y'
		and   v.suppress <> 'Y'
		and   p.suppress <> 'Y'
		and c.Extract_to_Shop_Sites <> 'N'
		and p.id is not null
		and p.name <> ''
		 and v.make > ''   and v.vehicletype in ('Car','CarVan')   and p.brand = 'Kamei' 
	order by v.make, v.model, v.year:<br>id 20<br>make:Alfa Romeo:11:47:16<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Alfa Romeo<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Alfa Romeo): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
make:Alpina BMW:11:47:17<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Alpina BMW<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Alpina BMW): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Alfa Romeo:<br>make:Audi:11:47:17<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Audi<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Audi): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Alpina BMW:<br>make:BMW:11:47:17<br>Making /www/domains/www.kamei-online.co.uk/makes_products_BMW<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_BMW): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Audi:<br>make:Chevrolet:11:47:18<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Chevrolet<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Chevrolet): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:BMW:<br>make:Chrysler:11:47:18<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Chrysler<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Chrysler): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Chevrolet:<br>make:Citroen:11:47:18<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Citroen<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Citroen): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Chrysler:<br>make:Dacia:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Dacia<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Dacia): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Citroen:<br>make:Daewoo:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Daewoo<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Daewoo): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Dacia:<br>make:Daihatsu:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Daihatsu<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Daihatsu): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Daewoo:<br>make:Fiat:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Fiat<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Fiat): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Daihatsu:<br>make:Ford:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Ford<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Ford): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Fiat:<br>make:Honda:11:47:19<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Honda<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Honda): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Ford:<br>make:Hyundai:11:47:20<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Hyundai<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Hyundai): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Honda:<br>make:Kia:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Kia<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Kia): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Hyundai:<br>make:Lancia:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Lancia<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Lancia): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Kia:<br>make:Mazda:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Mazda<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Mazda): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Lancia:<br>make:Mercedes Benz:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Mercedes Benz<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Mercedes Benz): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Mazda:<br>make:Mitsubishi:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Mitsubishi<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Mitsubishi): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Mercedes Benz:<br>make:Nissan:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Nissan<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Nissan): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Mitsubishi:<br>make:Opel:11:47:21<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Opel<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Opel): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Nissan:<br>make:Peugeot:11:47:22<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Peugeot<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Peugeot): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Opel:<br>make:Proton:11:47:23<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Proton<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Proton): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Peugeot:<br>make:Renault:11:47:23<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Renault<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Renault): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Proton:<br>make:Rover:11:47:23<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Rover<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Rover): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Renault:<br>make:Saab:11:47:23<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Saab<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Saab): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Rover:<br>make:Seat:11:47:23<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Seat<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Seat): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Saab:<br>make:Skoda:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Skoda<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Skoda): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Seat:<br>make:Smart:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Smart<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Smart): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Skoda:<br>make:Subaru:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Subaru<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Subaru): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Smart:<br>make:Suzuki:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Suzuki<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Suzuki): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Subaru:<br>make:Toyota:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Toyota<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Toyota): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Suzuki:<br>make:Vauxhall:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Vauxhall<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Vauxhall): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Toyota:<br>make:Volkswagen:11:47:24<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Volkswagen<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Volkswagen): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Vauxhall:<br>make:Volvo:11:47:25<br>Making /www/domains/www.kamei-online.co.uk/makes_products_Volvo<br>
<br />
<b>Warning</b>:  mkdir(/www/domains/www.kamei-online.co.uk/makes_products_Volvo): File exists in <b>/www/hosts/johnjor3/livescripts/reqfiles/rb/gencarindex.php</b> on line <b>1031</b><br />
prev make:Volkswagen:<br>