Browse Listings
By Dealer |
 |
UPDATE "Banner Ads"
SET Views=#Result#
WHERE Banner_ID=#Banner_ID#
Select Distinct Country from "ActiveListings" Where Country <> 'USA'
AND CompanyName <> ''
SELECT DISTINCT ContactID, CompanyName, City, State FROM ActiveListings WHERE
CompanyName LIKE '%Gerry%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%air%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Air%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Aerial%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Aero%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%aero%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Aviation%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Jet%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Wings%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Vicki%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Gardner%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%jet%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%LTD%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Ltd%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%fly%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Mamba%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Fly%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Helicopter%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Lasar%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Quality%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%QAS%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%flite%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Flite%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Warbird%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Jack Anderson%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%TAS%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%AvTecH%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Limited%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%GmbH%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%International%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%FVB%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Heli%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Casciola%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Dodson%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Seaplane%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Aero%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Arablink%' AND Country LIKE '%#Country#%' OR
CompanyName LIKE '%Tutt%' AND Country LIKE '%#Country#%'
ORDER BY State, CompanyName
