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 22:31:06'}) AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-06 22:31:06'}) 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=cftoken=0; cfid=a2c6ae75-c932-4c33-9f0f-13b097e98f53; CF_CLIENT_HANDWERK_LV=1775507466175; CF_CLIENT_HANDWERK_TC=1775507466175; CF_CLIENT_HANDWERK_HC=2 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=481 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=481 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=a2c6ae75-c932-4c33-9f0f-13b097e98f53 cftoken=0 hitcount=2 lastvisit={ts '2026-04-06 22:31:06'} timecreated={ts '2026-04-06 22:31:06'} urltoken=CFID=a2c6ae75-c932-4c33-9f0f-13b097e98f53&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=439B8DBE-7946-4DC4-882BDDF1E72FD417 cfid=a2c6ae75-c932-4c33-9f0f-13b097e98f53 cftoken=0 City= CompanyName= DocsPath=I:\WWW\handwerk.ch\docs\H\49240\ DOCSURL=http://test.handwerk.ch/docs/H/49240/ dollarkurs=1 dtOrdDate= EditMode=fckeditor Email= Eurokurs=1 Expires={ts '2026-04-06 22:31:06'} Fax= firma_adresse=Ingenieubüro für Elektrotechnik firma_adresszusatz=Tittwiesenstrasse 29 firma_anrede=Herr FIRMA_BRIEFANREDE= firma_crm_de= firma_crm_en= firma_email=info@nay.ch FIRMA_EMAIL2= firma_fax=081 286 99 10 firma_faxG= firma_feld1= firma_feld2= firma_feld3= firma_feld4=na firma_feld5= firma_homepage=http://www.nay.ch firma_homepage2= firma_id=49240 firma_kanton=GR firma_land= firma_mitglied=false firma_mob= firma_nachname=Nay firma_name=Nay + Partner AG firma_ort=Chur firma_passwort=hpnay firma_plz=6362 firma_portrait= firma_portrait_id= firma_sprache= FIRMA_SPRACHEN= firma_status=H2S08 firma_tel=081 286 99 00 firma_telD= firma_telG= firma_userid=info@nay.ch firma_vorname=Hanspeter 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 22:31:06'} LCity= LCompanyName= LFirstName= LLand= LLastName= logton= LPostCode= NEXTSTART=501 Password= payart=Rechnung Phone= PostCode= PREVSTART=461 Profil=true Profilfound=true PswdConfirm=hpnay RabattSatz=20 SaveKkA=0 SearchPremium=[46.9369702,8.276584599999978,"/1/logo-header.png","Precom Group AG","Horw","gl-real-estate-icon",52418],[47.52903825,8.708287748515149,"/1/logo-header.png","Malergeschäft Vaccaro-Hatt GmbH","Seuzach","gl-real-estate-icon",8262],[46.812023, 9.261801,"/51047/logo1.png","Maler Hunziker","Laax","gl-real-estate-icon",51047],[47.3496454,7.903233900000032,"/1/logo-header.png","La Rebelle Suisse Tattoo & Piercing GmbH","Olten","gl-real-estate-icon",52176],[47.3728925,8.524510599999985,"/1/logo-header.png","Klavier- und Flügelatelier Jürg Winiger","Zürich","gl-real-estate-icon",50908],[46.9432027,7.447865900000011,"/1/logo-header.png","IKB Integrale Kommunikations- Beratung AG ","Bern","gl-real-estate-icon",47970],[47.5733445,9.189027799999962,"/49964/LOGO Bättig Design 2012.jpg","Bättig Design","Berg TG","gl-real-estate-icon",49964],[47.3719988,8.5349129,"/1/logo-header.png","Grand Bau GmbH","Emmenbrücke","gl-real-estate-icon",53531],[47.4026365,8.494710899999972,"/1/logo-header.png","Glättli Manfred ","Zürich","gl-real-estate-icon",48157],[47.374312,8.000528411849267,"/1/logo-header.png","FHG Bauservice gmbh","Schönenwerd","gl-real-estate-icon",53710],[47.3673639,8.522226600000067,"/1/logo-header.png","Benzenhofer AG ","Zürich","gl-real-estate-icon",18405],[47.23686499999999,7.8160682999999835,"/1/logo-header.png","Awatex Schweiz","Roggwil","gl-real-estate-icon",50866],[47.1304349,9.5113399,"/1/logo-header.png","Böden Vielgut","Sevelen","gl-real-estate-icon",53707],[47.1957912,7.3925632,"/1/logo-header.png","Archbau","Grenchen","gl-real-estate-icon",53954],[47.1626337,8.292099300000018,"/1/logo-header.png","Emch+Berger WSB AG","Emmenbrücke","gl-real-estate-icon",49467],[47.3714297,8.6408047,"/1/logo-header.png","eazyclean","Fällanden","gl-real-estate-icon",53875],[47.2592456,8.8512977,"/1/logo-header.png","cool switch GmbH ","Rüti ","gl-real-estate-icon",53838],[47.2399937,8.82637939999995,"/1/logo-header.png","Cali Bodenbeläge GmbH","Jona ","gl-real-estate-icon",50401],[47.4206783,8.683643699999947,"/1/logo-header.png","Die Gartenprofis ","Effretikon","gl-real-estate-icon",50047],[47.3911266,8.4845817,"/1/logo-header.png","","Zürich","gl-real-estate-icon",53981],[47.40769115,8.552212786693936,"/1/logo-header.png","Kirnbauer Gartenpflege GmbH ","Zürich","gl-real-estate-icon",13933], sel_branche=0 sel_kanton= sel_keyword= sel_ort= sel_sub_branche=0 sel_typ= sessionid=Handwerk_a2c6ae75-c932-4c33-9f0f-13b097e98f53_0 SESSSTARTTIME={ts '2026-04-06 22:31:06'} SPRACHE=de STARTROW=481 strCustID= THEMAID=Suche timecreated={ts '2026-04-06 22:31:06'} urltoken=CFID=a2c6ae75-c932-4c33-9f0f-13b097e98f53&CFTOKEN=0 UserName=--- whitelisted=true

Login

Schenker Storen AG, St. Gallen

Schenker Storen AG, Solothurn

Schenker Storen AG, Olten

Schenker Stores SA, Neuchâtel

Schenker Storen AG, Luzern

Schenker Storen AG, Liestal

Schenker Stores SA, Givisiez

Schenker Storen AG, Eschenbach

Schenker Stores SA, Crissier

Schenker Storen AG, Chur

Schenker Stores SA, Carouge

Schenker Storen AG, Buchs

Schenker Storen AG, Brugg

Schenker Storen AG, Bern

Schenker Storen AG, Basel

Schenker Storen AG, Baden

Schenker Storen AG, Bachenbülach

Schenker Storen AG, Aarau

Schenker Storen AG, Baar

Qualiprom AG