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-08 02:30:15'}) AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-08 02:30:15'}) 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_LV=1775608215157; CF_CLIENT_HANDWERK_HC=2; cftoken=0; cfid=b9103386-18d5-4170-ac59-3b909b070b8c; CF_CLIENT_HANDWERK_TC=1775608215157 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=5461 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=5461 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=b9103386-18d5-4170-ac59-3b909b070b8c cftoken=0 hitcount=2 lastvisit={ts '2026-04-08 02:30:15'} timecreated={ts '2026-04-08 02:30:15'} urltoken=CFID=b9103386-18d5-4170-ac59-3b909b070b8c&CFTOKEN=0

Server Variables: CMSMASTER=Struct (2) coldfusion=Struct (9) counters=Struct (7) 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=93ADC517-27A7-4F47-AD68D59730B2049B cfid=b9103386-18d5-4170-ac59-3b909b070b8c cftoken=0 City= CompanyName= DocsPath=I:\WWW\handwerk.ch\docs\H\50401\ DOCSURL=http://test.handwerk.ch/docs/H/50401/ dollarkurs=1 dtOrdDate= EditMode=fckeditor Email= Eurokurs=1 Expires={ts '2026-04-08 02:30:15'} Fax= firma_adresse=St. Gallerstrasse 120 firma_adresszusatz= firma_anrede=Herr FIRMA_BRIEFANREDE= firma_crm_de= firma_crm_en= firma_email=info@bodenverleger.ch FIRMA_EMAIL2=info@m-cali.ch firma_fax=055 535 35 07 firma_faxG= firma_feld1= firma_feld2= firma_feld3= firma_feld4=47.2399937,8.82637939999995 firma_feld5= firma_homepage=https://www.bodenverleger.ch firma_homepage2= firma_id=50401 firma_kanton=SG firma_land= firma_mitglied=false firma_mob=076 319 94 60 firma_nachname=Cali firma_name=Cali Bodenbeläge GmbH firma_ort=Jona firma_passwort=asdf1234 firma_plz=8645 firma_portrait= firma_portrait_id= firma_sprache= FIRMA_SPRACHEN= firma_status=H8S07 firma_tel=055 535 35 07 firma_telD= firma_telG= firma_userid=info@m-cali.ch firma_vorname=Michele 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-08 02:30:15'} LCity= LCompanyName= LFirstName= LLand= LLastName= logton= LPostCode= NEXTSTART=5481 Password= payart=Rechnung Phone= PostCode= PREVSTART=5441 Profil=true Profilfound=true PswdConfirm=asdf1234 RabattSatz=20 SaveKkA=0 SearchPremium=[47.5285977,8.666472200000043,"/1/logo-header.png","Vögeli Alfred ","Neftenbach","gl-real-estate-icon",17430],[47.5628982,7.56941089999998,"/1/logo-header.png","Völlmin Hans ","Basel","gl-real-estate-icon",18691],[47.556487,7.576051499999949,"/1/logo-header.png","W + S Ingenieurbüro für Elektroplanung AG ","Basel","gl-real-estate-icon",18655],[47.3836255,8.549853299999995,"/1/logo-header.png","Wachter Willi Inhaber R. Mazzucco ","Zürich","gl-real-estate-icon",18472],[47.3601336,8.549496099999942,"/1/logo-header.png","Waechter Karl Ing. ","Zürich","gl-real-estate-icon",18473],[47.2027301,8.63512639999999,"/1/logo-header.png","Wagner Hansueli ","Schönenberg ZH","gl-real-estate-icon",17836],[47.0715457,8.291926800000055,"/1/logo-header.png","Wagner Unternehmungen AG ","Emmenbrücke","gl-real-estate-icon",19121],[47.2584165,8.85089400000004,"/1/logo-header.png","Waldvogel Haustechnik AG ","Rüti ZH","gl-real-estate-icon",17734],[47.2001676,8.525914000000057,"/1/logo-header.png","Waller Elektro-Handel ","Baar","gl-real-estate-icon",18602],[47.2860924,7.714353899999992,"/1/logo-header.png","Wallimann Haustechnik ","Oensingen","gl-real-estate-icon",17541],[46.9009355,8.25346920000004,"/1/logo-header.png","Wallimann Paul AG, Sanitäre Anlagen und Spenglerei ","Sarnen","gl-real-estate-icon",17764],[47.48746089999999,7.608886799999937,"/1/logo-header.png","Walliser Willy ","Dornach","gl-real-estate-icon",19070],[47.1685818,8.245395099999996,"/1/logo-header.png","Walther H. und Renggli W. AG ","Rain","gl-real-estate-icon",17601],[47.4864674,8.707963899999981,"/1/logo-header.png","Walti Erwin ","Winterthur","gl-real-estate-icon",18299],[46.94980779999999,7.4426584000000275,"/1/logo-header.png","Wanzenried + Hess AG ","Bern","gl-real-estate-icon",18809],[46.9568006,8.338611600000035,"/1/logo-header.png","Waser Elektrotechnik GmbH ","Ennetmoos","gl-real-estate-icon",19140],[46.5950297,9.598566399999981,"/1/logo-header.png","Wasescha David ","Savognin","gl-real-estate-icon",17768],[47.0341126,8.271464100000002,"/1/logo-header.png","Wasmer Engineering und Kommunikationstechnik ","Kriens","gl-real-estate-icon",19614],[47.4634041,8.990485000000035,"/1/logo-header.png","Wassegg GmbH ","Sirnach","gl-real-estate-icon",17885],[47.5645543,8.910908000000063,"/1/logo-header.png","Wasu Walter Suter AG ","Frauenfeld","gl-real-estate-icon",19231],[46.6593599,7.69995700000004,"/1/logo-header.png","WAT AG ","Aeschi b. Spiez","gl-real-estate-icon",18518], sel_branche=0 sel_kanton= sel_keyword= sel_ort= sel_sub_branche=0 sel_typ= sessionid=Handwerk_b9103386-18d5-4170-ac59-3b909b070b8c_0 SESSSTARTTIME={ts '2026-04-08 02:30:15'} SPRACHE=de STARTROW=5461 strCustID= THEMAID=Suche timecreated={ts '2026-04-08 02:30:15'} urltoken=CFID=b9103386-18d5-4170-ac59-3b909b070b8c&CFTOKEN=0 UserName=--- whitelisted=true

Login

Lennartz Wolfgang AG

Lampart Robert SARL

Rockwell Automation Switzerland GmbH

La Rebelle Suisse Tattoo & Piercing GmbH

KSW Wintergarten AG

Klavier- und Flügelatelier Jürg Winiger

Grand Bau GmbH

Blumer H. AG

Kündig AG, Josef, Flachbedachungen-Spenglerei

Kisso AG

Kirchhofer Gewächshaustechnik AG

Jungo Gartengestaltung AG

Itel AG Innenausbau

Huber Uhren Schmuck Anstalt

Böden Vielgut

Hinden AG Holzbau

Hengartner + Ritter AG

SC Haller AG

Gschwend Holzbau AG

Grütter Schlosserei + Maschinenbau GmbH