ALLIANCE

1 - 50 of 611

Active

21st May 2014


AAA STAR ALLIANCE LLC

NORTH HOLLYWOOD

Inactive

1st September 2018 - 19th November 2018


ACE ALLIANCE INC

LOS ANGELES

Active

1st August 2013


Active

27th January 2011


Active

1st December 2005


Inactive

15th November 2004 - 31st December 2006


AI ALLIANCE INC

LA MIRADA

Inactive

1st January 2004 - 16th September 2005


Inactive

1st May 2000 - 31st December 2000


ALL WIN ALLIANCE INC

LOS ANGELES

Inactive

27th February 2004 - 31st July 2006


ALLIANCE BERNSTEIN LP

LOS ANGELES

Active

1st October 2000


Active

1st February 2019


ALLIANCE 26 LLC

LOS ANGELES

Active

1st September 2003


ALLIANCE 26 LLC

LOS ANGELES

Inactive

17th September 2014 - 31st March 2016


Inactive

15th August 2002 - 1st January 2007


Inactive

1st July 1997 - 31st December 1999


Inactive

1st September 1985 - 10th May 1996


Active

1st January 2011


Inactive

3rd August 1999 - 31st December 2009


Active

7th May 2014


Inactive

13th April 2001 - 31st December 2015


ALLIANCE APPAREL INC

LOS ANGELES

Inactive

1st January 2001 - 18th July 2002


ALLIANCE APPAREL INC

LOS ANGELES

Inactive

1st July 2007 - 31st December 2015


Active

10th October 2007


Inactive

1st January 2009 - 31st December 2015


Inactive

30th July 2012 - 31st December 2013


Inactive

1st January 1972 - 31st December 2014


Inactive

1st January 1972 - 31st May 2006


Inactive

1st January 1972 - 31st May 2006


ALLIANCE BRENTWOOD LP

LOS ANGELES

Active

15th June 2014


Inactive

1st January 2001 - 1st November 2004


Inactive

13th April 2009 - 31st December 2013


Active

4th June 2013


Inactive

1st January 2003 - 31st December 2012


Inactive

12th October 2000 - 31st December 2003


Inactive

8th May 1995 - 1st August 2006


Active

1st June 2016


Inactive

2nd July 2003 - 31st December 2003


Inactive

1st January 1984 - 31st December 2009


Active

26th October 2011


Inactive

1st October 1997 - 31st January 2015


ALLIANCE CLOUD LLC

LOS ANGELES

Active

21st September 2018


Active

22nd July 2014


Inactive

1st May 2011 - 18th July 2012


Inactive

21st January 1999 - 31st December 2005


Active

18th December 2007


Inactive

2nd September 2008 - 31st December 2012


Active

1st January 2011


Active

2nd January 2017


Inactive

26th December 2007 - 31st December 2010


Active

1st May 2014


(default) 2 queries took 21 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 ( '(+ALLIANCE)' IN BOOLEAN MODE) ORDER BY `Record`.`BUSINESS_NAME` ASC LIMIT 50505019
2SELECT COUNT(*) AS `count` FROM `la_business`.`records` AS `Record` WHERE MATCH (`Record`.`BUSINESS_NAME`, `Record`.`CITY`, `Record`.`ZIP_CODE`) AGAINST ( '(+ALLIANCE)' IN BOOLEAN MODE)112