Handwerk, Suche

SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE, AuthObject, AnzSubKat, Description AuthObject FROM Themen where ThemaID='Suche' and Phase='online'

SELECT Artikel.ArtikelID, Artikel.Titel, Artikel.Link1, Artikel.Link2, Artikel.Bild1, Artikel.Bild2, Artikel.Text1, Artikel.Text2 FROM Artikel RIGHT JOIN (Themen LEFT JOIN Themen_Artikel ON Themen.ThemaID = Themen_Artikel.ThemaID) ON Artikel.ArtikelID = Themen_Artikel.ArtikelID where Themen.ThemaID = 'Suche' AND Artikel.Phase = 'online' AND (Artikel.OnlineVon is null or Artikel.OnlineVon < {ts '2026-04-06 20:56:17'}) AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-06 20:56:17'}) Order By Themen_Artikel.SortPos asc;

SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat FROM Themen Where Themen.HauptThema = 'Angebot' and Themen.Phase='online' order by ThemaPrio

SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat FROM Themen Where Themen.HauptThema = 'Ausschreibungen' and Themen.Phase='online' order by ThemaPrio

SELECT ThemaID, ThemaBild, ThemaName, ThemaText, Hauptthema, ThemaLink, THEMATEMPLATE , AuthObject , AnzSubKat FROM Themen Where Themen.HauptThema = 'Ratgeber' and Themen.Phase='online' order by ThemaPrio

SELECT DISTINCT firmen.firma_id , firmen.firma_name , firmen.firma_adresse , firmen.firma_plz , firmen.firma_tel firmen.firma_ort , firmen.firma_homepage , firmen.firma_mitglied , firmen.firma_status, firmen.firma_Feld2, firmen.firma_nachname, firmen.firma_anrede, firmen.firma_ort, firmen.firma_vorname, abo.*, firmen.firma_modifiziert FROM (firmen LEFT JOIN relations ON firmen.firma_id = relations.rel_firma_id) LEFT JOIN branchen ON relations.rel_bra_id = branchen.bra_id LEFT JOIN abo ON firmen.firma_id = abo.abo_firma_id WHERE (firma_status NOT LIKE 'A%' and firma_status NOT LIKE '%X%') -- ORDER BY case WHEN abo.abo_name is null then 1 else 0 end, case WHEN firmen.firma_feld2 is null then 1 else 0 end, abo.abo_name, firmen.firma_mitglied DESC, firmen.firma_Feld2 DESC ORDER BY case WHEN firmen.firma_feld2 = '' then 1 else 0 end, firmen.firma_mitglied DESC, firmen.firma_modifiziert DESC, firmen.firma_name ASC

SELECT DISTINCT firma_id, firma_name, firma_ort, firma_Feld2, firma_Feld4, firma_status ,firma_homepage , firma_mitglied, abo.abo_id, abo.dtaboablauf, firmen.firma_modifiziert FROM (firmen LEFT JOIN relations ON firmen.firma_id = relations.rel_firma_id) LEFT JOIN branchen ON relations.rel_bra_id = branchen.bra_id LEFT JOIN abo ON firmen.firma_id = abo.abo_firma_id WHERE firma_Feld4 <> '' and firma_Feld4 != 'na' ORDER BY firmen.firma_mitglied DESC, firmen.firma_modifiziert DESC, firmen.firma_name ASC

Application Variables: ADMINURL=Admin ADMINVERSION=2024051601 applicationname=Handwerk AUFTRAGURL=http://test.handwerk.ch//docs/A/ COLLECTIONPATH=I:\WWW\handwerk.ch\verity COOKIECONSENTPOPUP=true CURRENCY2=EUR DATASOURCE=handwerk_cms DATASOURCE2=handwerk DATASOURCE_ADM=handwerk_cms DIRHM=I:\WWW\handwerk.ch\ DocsPath=docs FIRMAURL=http://test.handwerk.ch//docs/H/ FROM=handwerk.ch <news@handwerk.ch> HM=/ LZ=999 MaxRows=50 MENU=cms_MMenu.cfm MWST_INOROUT=Inklusive MYEMAIL=info@handwerk.ch MYPOS_URL=https://www.mypos.eu/vmp/checkout-test MYPOSSID=000000000000010 MYPOSURLCANCEL=http://test.handwerk.ch/shop_myPos_response.cfm?Cancel MYPOSURLNOTIFY=https://test.handwerk.ch/shop_myPos_response.cfm?Notify MYPOSURLOK=http://test.handwerk.ch/shop_myPos_response.cfm?OK MYPOSWALLETNUMBER=61938166610 MYURL=http://test.handwerk.ch/ NAME=Handwerk NMPATH=nm ORDERDOCUMENTBASEPATH=I:\WWW\handwerk.ch\orders ORDERDOCUMENTBASEURL=/orders PortoCH=0 PortoEU=0 RABATTBEZEICHNUNG=SuperDuper RABATTSATZ=0.33 REFCURRENCY=CHF REFLAND=CHE REFSPRACHE=-ch SHOP_MYPOS_KEYINDEX=1 SHOP_MYPOS_PRIVATECERT_PATH=converted_handwerk_mypos_private_key.pem SHOP_MYPOS_PUBLICCERT_PATH=converted_handwerk_mypos_public_key.pem SHOP_MYPOS_STOREID=114219 SHOP_MYPOS_URL=https://www.mypos.com/vmp/checkout SHOP_MYPOS_WALLETID=40071437194 SHOP_PAYPAL_MERCHID=AcXYX6RW241B2O0UbCVPtjx5j7zIy6yiRTV1T8-Royaw3trDYE4EaA6m4weD9_3MGR-ilTG8FJe655C2 SHOP_PAYPAL_SECRET=EG-UQGcYPJp8JfG6F6qXD9BL7qDrwpC2q2-FLdAsVYwDiaQCZfQIW8CQLXCBT11Q_lbPQKZBm-6_tUrO SHOP_PAYPAL_URL=https://api-m.paypal.com SHOP_RECHNUNG_BILD=docs/Angebot.png SHOP_RECHNUNG_CREDITORADDRESS1=Seefeldstrasse 94 SHOP_RECHNUNG_CREDITORCITY=Zurich SHOP_RECHNUNG_CREDITORLAND=CH SHOP_RECHNUNG_CREDITORNAME=Handwerk.ch GmbH SHOP_RECHNUNG_CREDITORNO= SHOP_RECHNUNG_CREDITORPOSTCODE=8008 SHOP_RECHNUNG_QRIBAN=CH0530000001607931348 SHOP_RECHNUNG_TEXT=PHN0eWxlPg0KLnN1YnRpdGxlMSB7DQoJZm9udC13ZWlnaHQ6MTAwOw0KCWZvbnQtc2l6ZToxM3B4CTsNCgljb2xvcjpibGFjazsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCi5zdWJ0aXRsZTIgew0KCWZvbnQtd2VpZ2h0OjEwMDsNCglmb250LXNpemU6MTNweAk7DQoJY29sb3I6IzgwODA4MDsNCgl0ZXh0LWFsaWduOiByaWdodDsNCgljbGVhcjpyaWdodDsNCn0NCjwvc3R5bGU+DQo8ZGl2Pg0KCQkJPGltZyBzcmM9Ii9kb2NzL0xvZ28tZGlyZWN0b3J5LXJnYi5qcGciIHN0eWxlPSJ3aWR0aDogMjAwLjAwcHg7IGhlaWdodDogNTAuMDBweDsgZmxvYXQ6bGVmdCIgdGl0bGU9IiI+DQoJCQk8cCBjbGFzcz0ic3VidGl0bGUxIj5IYW5kd2Vyay5jaCBHbWJIPC9wPg0KCQkJPHAgY2xhc3M9InN1YnRpdGxlMiI+U2VlZmVsZHN0cmFzc2UgOTQsIDgwMDggWsO8cmljaDwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPlRlbC4gMDQ0IDM4MyAwMSAwMzwvcD4NCgkJCTxwIGNsYXNzPSJzdWJ0aXRsZTIiPmluZm9AaGFuZHdlcmsuY2ggPC9wPg0KCQkJPGJyPjxicj48YnI+DQoJCQkNCiAgICAgICAgPC9kaXY+ SHOPAKTION=n SHOPBCC=ap@trenka.ch shopFaceProperties=pdf editOrder report SHOPFROM=ap@trenka.ch SHOPPATH=shop SHOPTOCC=ap@trenka.ch SPAMcheckemail=Array (0) SPAMcheckIPs=Array (0) SPRACHEN=DE sprachen_lang_DE=Struct (382) STATUS=Open SURVEYACCOUNT=www.handwerk.ch SURVEYDB=handwerk_Survey SURVEYEMAIL=info@handwerk.ch SURVEYVIEW=survey.cfm TaxRate=0 TimeoutcheckIPs=Array (0)

CGI Variables: auth_password= auth_type= auth_user= cert_cookie= cert_flags= cert_issuer= cert_keysize= cert_secretkeysize= cert_serialnumber= cert_server_issuer= cert_server_subject= cert_subject= cf_template_path=I:\WWW\handwerk.ch\h_suche.cfm content_length= content_type= context_path= gateway_interface=CGI/1.1 http_accept=*/* http_accept_encoding=gzip, br, zstd, deflate http_accept_language= http_connection=keep-alive http_cookie=CF_CLIENT_HANDWERK_TC=1775501776391; cfid=93e32273-832a-442a-802e-fdc39c76a648; CF_CLIENT_HANDWERK_HC=3; cftoken=0; CF_CLIENT_HANDWERK_LV=1775501776948 http_host=test.handwerk.ch http_referer= http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) https=off https_keysize= https_secretkeysize= https_server_issuer= https_server_subject= local_addr=193.16.211.5 local_host=Notos path_info= path_translated=I:\WWW\handwerk.ch\h_suche.cfm query_string=StartRow=461 remote_addr=216.73.216.40 remote_host=216.73.216.40 remote_user= request_method=GET request_url=http://test.handwerk.ch/h_suche.cfm?StartRow=461 script_name=/h_suche.cfm server_name=test.handwerk.ch server_port=80 server_port_secure=0 server_protocol=HTTP/1.1 server_software= web_server_api=

Client Variables: cfid=93e32273-832a-442a-802e-fdc39c76a648 cftoken=0 hitcount=3 lastvisit={ts '2026-04-06 20:56:16'} timecreated={ts '2026-04-06 20:56:16'} urltoken=CFID=93e32273-832a-442a-802e-fdc39c76a648&CFTOKEN=0

Server Variables: CMSMASTER=Struct (2) coldfusion=Struct (9) counters=Struct (104) form_ipaddress= form_value= java=Struct (9) lucee=Struct (9) os=Struct (8) separator=Struct (3) servlet=Struct (1) SPAM_App_Blacklist_Query=Query (0) SPAM_Blacklist_Query=Query (1598) SPAM_RequestBlock_Query=Query (8) SPAM_Sync=Struct (4) SPAM_Whitelist_Query=Query (13) system=Struct (2)

Session Variables: ActAppl=CMSmaster Address1= Address2= ADS=Query (0) Bemerkungen= CardName= CardNum=0000 0000 0000 1234 CardNum2=000 CardTyp= CartID=A289B5A1-CD3E-4DFE-AC0F592DACC8EDE4 cfid=93e32273-832a-442a-802e-fdc39c76a648 cftoken=0 City= CompanyName= DocsPath=I:\WWW\handwerk.ch\docs\H\50539\ DOCSURL=http://test.handwerk.ch/docs/H/50539/ dollarkurs=1 dtOrdDate= EditMode=fckeditor Email= Eurokurs=1 Expires={ts '2026-04-06 20:56:16'} Fax= firma_adresse=Murtenstrasse 502 firma_adresszusatz= firma_anrede=Herr FIRMA_BRIEFANREDE= firma_crm_de= firma_crm_en= firma_email=baumannbaumpflege@gmail.com FIRMA_EMAIL2= firma_fax= firma_faxG= firma_feld1= firma_feld2= firma_feld3= firma_feld4=46.948268,7.362079200000039 firma_feld5= firma_homepage=http:// firma_homepage2= firma_id=50539 firma_kanton=BE firma_land= firma_mitglied=false firma_mob= firma_nachname=Baumann firma_name=Baumann Baumpflege & Gartenbau firma_ort=Bern firma_passwort=kanada firma_plz=3027 firma_portrait= firma_portrait_id= firma_sprache= FIRMA_SPRACHEN= firma_status=H2S09 firma_tel=079 374 98 30 firma_telD= firma_telG= firma_userid=baumannbaumpflege@gmail.com firma_vorname=Peter FirstName= h_logton_Attribute= h_logton_userid= HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) IPADDR=216.73.216.40 JumpBack2=shop_payment.cfm LAddress1= LAddress2= Land= LastName= lastvisit={ts '2026-04-06 20:56:17'} LCity= LCompanyName= LFirstName= LLand= LLastName= logton= LPostCode= NEXTSTART=481 Password= payart=Rechnung Phone= PostCode= PREVSTART=441 Profil=true Profilfound=true PswdConfirm=kanada RabattSatz=20 SaveKkA=0 SearchPremium=[47.4040674,8.047384899999997,"/1/logo-header.png","Peter Egger Umbauten/Renovationen","Rombach","gl-real-estate-icon",49280],[47.1960619,8.479717599999958,"/48408/avatar.jpg","Tauch-Treff AG","Steinhausen","gl-real-estate-icon",48408],[47.4934706,8.7592368,"/1/logo-header.png","Brunner Parkett Sewiteppich AG","Winterthur","gl-real-estate-icon",54029],[47.3565655,8.274993606201546,"/1/logo-header.png","Jankovity Bau und Reinigung ","Wohlen AG ","gl-real-estate-icon",54015],[47.50253385,8.945704297200198,"/1/logo-header.png"," EUROGRANIT NATURSTEINWERK GMBH","Wängi","gl-real-estate-icon",53964],[47.4357272,9.4045653,"/1/logo-header.png","LUKI Sàrl","Bulle","gl-real-estate-icon",53817],[47.15675065,8.094902843294866,"/1/logo-header.png","Tabou-rettli. News","Oberkirch LU","gl-real-estate-icon",53834],[46.92723429999999,7.416810299999952,"/52532/Log-sunbit.png","Sunbilt AG","Bern-Liebefeld","gl-real-estate-icon",52532],[46.8887001,7.3276703000000225,"/1/logo-header.png","Stalder&Partner AG","Flamat ","gl-real-estate-icon",49739],[46.9001421,7.24135810000007,"/1/logo-header.png","Sicherheitsberatungen Wyder","Laupen","gl-real-estate-icon",49552],[47.6874999,9.831800499999985,"/1/logo-header.png","Schättin Bauleitung & Planung","Wangen","gl-real-estate-icon",48267],[47.7716025,8.680812100000025,"/1/logo-header.png","Bührer & Richter AG ","Bibern SH","gl-real-estate-icon",50804],[47.5490219,7.627657699999986,"/49074/Regenbogen-logo.gif","Birs Parkett GmbH","Birsfelden","gl-real-estate-icon",49074],[47.2264353,8.546704299999987,"/1/logo-header.png","AK Sonnenschutzfolien","Cham","gl-real-estate-icon",52030],[47.3034052,8.313801699999999,"/1/logo-header.png","Werder Wohnbedarf","Boswil","gl-real-estate-icon",49576],[47.345522,8.805710900000008,"/1/logo-header.png","Triptrap Woca Parketpflege Onlineshop","Auslikon","gl-real-estate-icon",49260],[47.4511985,8.4319299,"/1/logo-header.png","Texolit AG","Buchs","gl-real-estate-icon",52145],[47.22293879999999,8.240365900000028,"/1/logo-header.png","Süess Gartenbau AG ","Ermensee","gl-real-estate-icon",50436],[47.2614703,8.414633600000002,"/1/logo-header.png","Servrail GmbH","Bern","gl-real-estate-icon",52742],[47.5188961,8.586795299999948,"/1/logo-header.png","S24.ch GmbH","Embrach","gl-real-estate-icon",50692],[46.9369702,8.276584599999978,"/1/logo-header.png","Precom Group AG","Horw","gl-real-estate-icon",52418], sel_branche=0 sel_kanton= sel_keyword= sel_ort= sel_sub_branche=0 sel_typ= sessionid=Handwerk_93e32273-832a-442a-802e-fdc39c76a648_0 SESSSTARTTIME={ts '2026-04-06 20:56:16'} SPRACHE=de STARTROW=461 strCustID= THEMAID=Suche timecreated={ts '2026-04-06 20:56:16'} urltoken=CFID=93e32273-832a-442a-802e-fdc39c76a648&CFTOKEN=0 UserName=--- whitelisted=true

Login

Nay + Partner AG

Nay + Partner AG

Preite-Glas

Pfister Spenglerei

M. Suter AG

Edelsteinschleiferei Engeli

Baummaa Baum- und Gartenpflege

ByHandclap - Potrade GmbH

Debi Umzug

CADLUX

Nussbaum Sanitär & Heizung GmbH

örgeli-studio

Schenker Storen AG, Service

Schenker Storen AG, Zürich

Schenker Storen AG, Zermatt

Schenker Storen AG, Winterthur

Schenker Storen AG, Visp

Tende Schenker SA, Ticino Sud

Tende Schenker SA, Ticino Nord

Schenker Storen AG, Sursee