Anwaltssuche Hetlinger Neuerkoog

	
	Array
(
    [0] => www.rechtsanwalt.net
    [1] => rechtsanwalt
    [2] => hetlinger-neuerkoog
)
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 = 'hetlinger-neuerkoog' 
 Dauer in ms:0.012649059295654
###########

Params: cl=searchlanding&landing=1&lp_city=Hetlinger Neuerkoog


###########
 SQL: select SQL_CALC_FOUND_ROWS * from category 
 Dauer in ms:0.00039792060852051
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00015997886657715
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from subcategory 
 Dauer in ms:0.0016088485717773
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00018310546875
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from cat_cat 
 Dauer in ms:0.00025105476379395
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00013899803161621
###########
###########
 SQL: select * from geodata where  geodata.city = 'Hetlinger Neuerkoog' 
 Dauer in ms:0.0004119873046875
###########
###########
 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.9363424401574) * (sin(RADIANS(c.lng)) *
						 sin(0.16890406382883) + cos(RADIANS(c.lng)) * 
						 cos(0.16890406382883)) - sin(RADIANS(c.lat)) * sin(0.9363424401574)))) 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.9363424401574) * (sin(RADIANS(c.lng)) * 
						 sin(0.16890406382883) + cos(RADIANS(c.lng)) * 
						 cos(0.16890406382883)) - sin(RADIANS(c.lat)) * sin(0.9363424401574))) <= 25 
						 
						 group by staff_lastname
						 ORDER BY bewertung DESC, bewertung2 DESC, Distance LIMIT 0,12
 Dauer in ms:1.4640488624573
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00018215179443359
###########

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: 0 in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 538



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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



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



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



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



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



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 variable: seorechtsgebiet in /kunden/321160_76133/webseiten/rechtsanwalt-php7/core/companylist.php on line 542



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


###########
 SQL: select SQL_CALC_FOUND_ROWS match(sp.name, ca.name, cc.name, s.firstname, s.lastname, c.name, c.zip, c.street, c.city, g.region1, g.region2, g.region3, g.region4, g.area1) against(' Hetlinger Neuerkoog 25492'  IN BOOLEAN MODE) as score, c.id, c.name, c.claim, c.city, c.street, c.zip, c.url, c.type, c.email, c.phone, c.firstname, c.lastname, c.emblem, co.staff_nr, s.firstname as staff_firstname, s.lastname as staff_lastname, s.id as staff_id, s.picture as staff_picture,
			ca.id as category_id, ca.name as category_name, sp.id as specialism_id, sp.name as specialism_name
			, 6371 * ACos( Cos( RADIANS( '53.64847' ) ) * Cos( RADIANS( g.lat  ) ) * Cos( RADIANS( g.lng ) - RADIANS( '9.67749' ) ) + Sin( RADIANS( '53.64847' ) ) * Sin( RADIANS( g.lat ) ) ) AS distance
			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 geodata g on (c.zip = g.zip)
			where match(sp.name, ca.name, cc.name, s.firstname, s.lastname, c.name, c.zip, c.street, c.city, g.region1, g.region2, g.region3, g.region4, g.area1) against(' Hetlinger Neuerkoog 25492'  IN BOOLEAN MODE) > 0 and (c.type = 'company' )   
			group by c.id order by score desc, distance, FIND_IN_SET(c.type,'company,platin,gold,siber,single,basis,list,free') LIMIT 0,12
 Dauer in ms:0.011322021484375
###########
###########
 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.084542989730835
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00024604797363281
###########
###########
 SQL: select SQL_CALC_FOUND_ROWS * from staff 
 Dauer in ms:0.019423961639404
###########
###########
 SQL: SELECT  FOUND_ROWS()
 Dauer in ms:0.00027680397033691
###########