Array
(
    [0] => www.rechtsanwalt.net
    [1] => rechtsanwalt
    [2] => schwalbach-am-taunus
    [3] => mietrecht
)
Array
(
    [0] => rechtsanwalt
)
Variable:rechtsanwalt

Deprecated:  The each() function is deprecated. This message will be suppressed on further calls in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/object.php on line 213


###########
 SQL: select * from geodata where  geodata.stadtsuche = 'schwalbach-am-taunus' 
 Dauer in ms:0.012525796890259
###########
###########
 SQL: select * from geodata where  geodata.stadtsuche = 'schwalbach-am-taunus' 
 Dauer in ms:0.012234926223755
###########
###########
 SQL: select c.id, c.name, c.text from category c left join cat_cat cc on (c.id = cc.category_id) 
								where c.linktext = "mietrecht" or cc.name = "mietrecht"
 Dauer in ms:0.00066494941711426
###########

Params: cl=searchlanding&landing=1&lp_city=Schwalbach am Taunus&lpsearch_cat=Miet- und Wohnungseigentumsrecht


###########
 SQL: select SQL_CALC_FOUND_ROWS * from category 
 Dauer in ms:0.00033998489379883
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00014781951904297
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from subcategory 
 Dauer in ms:0.0015439987182617
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00020194053649902
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from cat_cat 
 Dauer in ms:0.00026106834411621
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00016617774963379
###########
###########
 SQL: select * from geodata where  geodata.city = 'Schwalbach am Taunus' 
 Dauer in ms:0.00037503242492676
###########
Ergebnis : 34

###########
 SQL: SELECT c.id, c.name, c.claim, c.city, c.street, c.zip, c.url, c.type, c.email, c.phone, c.firstname, c.lastname, co.staff_nr, s.firstname as staff_firstname, s.gender as staff_gender, s.title as staff_title, s.nameaffix as staff_nameaffix,s.lastname as staff_lastname, s.id as staff_id, s.picture as staff_picture,(
						 6368 * SQRT(2*(1-cos(RADIANS(c.lat)) * 
						 cos(0.87526202498998) * (sin(RADIANS(c.lng)) *
						 sin(0.14903523562412) + cos(RADIANS(c.lng)) * 
						 cos(0.14903523562412)) - sin(RADIANS(c.lat)) * sin(0.87526202498998)))) AS Distance,
						(SELECT sum((rating1 + rating2 + rating3 + rating4+ rating5)/5)/COUNT(idanwalt) as gesamtdurchschnitt FROM detailbewertung WHERE freischaltenadmin = 1 and detailbewertung.idanwalt = c.id) as bewertung,	
						(SELECT COUNT(idanwalt) as gesamtdurchschnitt FROM detailbewertung WHERE freischaltenadmin = 1 and detailbewertung.idanwalt = c.id) as bewertung2,
						sp.name	
							
						 FROM company c
						left join contract co on (co.company_id = c.id)
						left join staff s on (c.id = s.company_id)
						left join staff_category sc on (sc.staff_id = s.id)
						left join staff_specialism ss on (ss.staff_id = s.id)
						left join category ca on (ca.id = sc.category_id)
						left join cat_cat cc on (cc.category_id = ca.id)
						left join specialism sp on (sp.id = ss.specialism_id)
						left join detailbewertung db on (db.idanwalt = s.id)
						WHERE 
						 6368 * SQRT(2*(1-cos(RADIANS(c.lat)) * 
						 cos(0.87526202498998) * (sin(RADIANS(c.lng)) * 
						 sin(0.14903523562412) + cos(RADIANS(c.lng)) * 
						 cos(0.14903523562412)) - sin(RADIANS(c.lat)) * sin(0.87526202498998))) <= 25 
						  and ca.id = '34' 
						 group by staff_lastname
						 ORDER BY bewertung DESC, bewertung2 DESC, Distance LIMIT 0,12
 Dauer in ms:0.070472955703735
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00017905235290527
###########

Notice:  Object of class stdClass could not be converted to int in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/listing.php on line 206



Notice:  Undefined variable: rating1 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 478



Notice:  Undefined variable: rating2 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 479



Notice:  Undefined variable: rating3 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 480



Notice:  Undefined variable: rating4 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 481



Notice:  Undefined variable: rating5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 482



Notice:  Undefined offset: 4 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 486



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 487



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 488



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 489



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 490



Notice:  Undefined offset: 4 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 486



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 487



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 488



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 489



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 490



Notice:  Undefined offset: 4 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 486



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 487



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 488



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 489



Warning:  Division by zero in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 490



Notice:  Undefined offset: 5 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined offset: 6 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



Notice:  Undefined variable: umkreisrechtstipps in /kunden/321160_76133/webseiten/rechtsanwalt-php7/main/searchlanding.php on line 658


###########
 SQL: select c.*, count(c.id) as cnt_staff from category c
		right join staff_category s on (s.category_id = c.id ) where c.id IS NOT NULL group by c.id order by cnt_staff DESC
 Dauer in ms:0.082381010055542
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00021600723266602
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from staff 
 Dauer in ms:0.018623828887939
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.0003359317779541
###########