AMERICAN CYN

1 - 50 of 3285

Inactive

1st August 1975 - 31st December 2008


Active

1st January 2004


Active

14th June 2010


Inactive

15th January 2006 - 31st December 2012


Active

1st January 2015


Inactive

30th October 1997 - 22nd August 1998


Inactive

21st September 2011 - 31st December 2012


Inactive

1st May 2004 - 31st December 2010


Inactive

1st March 1996 - 1st November 2004


Active

26th January 2009


Inactive

7th January 1994 - 31st December 2010


Inactive

15th January 2008 - 31st December 2013


Active

1st July 1989


Inactive

1st May 1995 - 1st November 2004


Active

2nd November 2017


Inactive

23rd June 2005 - 31st December 2005


Inactive

12th November 2009 - 30th June 2017


Inactive

1st January 2008 - 25th May 2016


Inactive

21st March 2008 - 31st December 2017


Inactive

11th September 2003 - 10th December 2003


Inactive

10th February 2008 - 31st December 2014


Inactive

1st January 1993 - 31st December 1995


Inactive

22nd August 2011 - 31st December 2014


Inactive

1st January 2014 - 14th June 2014


Active

1st September 1998


Inactive

25th March 2011 - 21st December 2011


Inactive

8th April 1983 - 1st April 1999


Active

10th April 1993


Inactive

1st October 1982 - 31st December 1999


Active

12th January 2004


Inactive

1st June 1990 - 31st December 2015


Active

21st August 2015


Active

7th September 2000


Inactive

1st March 2000 - 31st July 2003


Active

13th December 1997


Active

20th June 1996


Active

9th February 2018


Inactive

1st January 2002 - 16th November 2005


Inactive

6th July 2016 - 1st June 2017


Inactive

1st March 1997 - 31st December 1998


Active

10th December 1991


Active

12th May 1992


Active

10th January 2005


Inactive

2nd August 1993 - 31st December 2004


AIR AMERICAN INC

CANYON COUNTRY

Active

28th November 2012


Active

1st July 1970


Active

30th March 2017


Inactive

7th April 1999 - 1st November 2004


Active

1st September 1993


Inactive

1st June 1973 - 30th June 2002


(default) 2 queries took 167 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Record`.`id`, `Record`.`Location_Account`, `Record`.`BUSINESS_NAME`, `Record`.`DBA_NAME`, `Record`.`STREET_ADDRESS`, `Record`.`CITY`, `Record`.`ZIP_CODE`, `Record`.`LOCATION_DESCRIPTION`, `Record`.`MAILING_ADDRESS`, `Record`.`MAILING_CITY`, `Record`.`MAILING_ZIP_CODE`, `Record`.`NAICS`, `Record`.`PRIMARY_NAICS_DESCRIPTION`, `Record`.`COUNCIL_DISTRICT`, `Record`.`LOCATION_START_DATE`, `Record`.`LOCATION_END_DATE`, `Record`.`LOCATION` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+AMERICAN +CYN)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 50505085
2SELECT COUNT(*) AS `count` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+AMERICAN +CYN)' IN BOOLEAN MODE)1182