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

SELECT   ThemaID, ThemaBild, ThemaName, ThemaText, ThemaLink, AnzSubKat, AuthObject
				FROM         Themen 
				where Hauptthema='TopMenu' and Phase='online' order by ThemaPrio

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-04 23:29:42'})
				AND (Artikel.OnlineBis is null or Artikel.OnlineBis > {ts '2026-04-04 23:29:42'})
				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 branchen.bra_ID, branchen.bra_name, branchen.bra_gruppe from branchen where branchen.bra_gruppe = 0 ORDER BY branchen.bra_name asc

select branchen.bra_ID, branchen.bra_name , branchen.bra_gruppe from branchen where branchen.bra_gruppe = 0 ORDER BY branchen.bra_name asc

SELECT  kanton, kanton_name FROM  kantone ORDER BY kanton_name

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=1775338182610; cftoken=0; CF_CLIENT_HANDWERK_HC=2; CF_CLIENT_HANDWERK_LV=1775338182610; cfid=ccc74e41-5041-4f18-b255-7c874db2bafd
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=41
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=41
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=ccc74e41-5041-4f18-b255-7c874db2bafd
cftoken=0
hitcount=2
lastvisit={ts '2026-04-04 23:29:42'}
timecreated={ts '2026-04-04 23:29:42'}
urltoken=CFID=ccc74e41-5041-4f18-b255-7c874db2bafd&CFTOKEN=0

Cookie Variables:
cf_client_handwerk_hc=2
cf_client_handwerk_lv=1775338182610
cf_client_handwerk_tc=1775338182610
cfid=ccc74e41-5041-4f18-b255-7c874db2bafd
cftoken=0

Server Variables:
CMSMASTER=Struct (2)
coldfusion=Struct (9)
counters=Struct (32)
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=CA304EDC-AD02-406F-BC652638417BEDE6
cfid=ccc74e41-5041-4f18-b255-7c874db2bafd
cftoken=0
City=
CompanyName=
DocsPath=I:\WWW\handwerk.ch\docs\H\54371\
DOCSURL=http://test.handwerk.ch/docs/H/54371/
dollarkurs=1
dtOrdDate=
EditMode=fckeditor
Email=
Eurokurs=1
Expires={ts '2026-04-04 23:29:42'}
Fax=
firma_adresse=Ringstrasse 11
firma_adresszusatz=
firma_anrede=Herr
FIRMA_BRIEFANREDE=
firma_crm_de=
firma_crm_en=
firma_email=info@maler-rupp.ch
FIRMA_EMAIL2=
firma_fax=
firma_faxG=
firma_feld1=Maler Rupp
firma_feld2=avatar.jpg
firma_feld3=Maler Rupp ist spezialisiert auf eine Vielzahl von Maler- und Dekorationsdienstleistungen, die darauf abzielen, das Aussehen und die Qualität in Ihrem Zuhause, Geschäft oder Büro zu verbessern. 
firma_feld4=47.33063145,7.843427071637581
firma_feld5=
firma_homepage=https://www.maler-rupp.ch/
firma_homepage2=
firma_id=54371
firma_kanton=SO
firma_land=
firma_mitglied=false
firma_mob=
firma_nachname=Rupp
firma_name=Maler Rupp
firma_ort=Hägendorf
firma_passwort=171B1704
firma_plz=4614
firma_portrait=
firma_portrait_id=
firma_sprache=
FIRMA_SPRACHEN=
firma_status=HS12
firma_tel=0799053525
firma_telD=
firma_telG=
firma_userid=info@maler-rupp.ch
firma_vorname=Jeremy
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-04 23:29:42'}
LCity=
LCompanyName=
LFirstName=
LLand=
LLastName=
logton=
LPostCode=
NEXTSTART=61
Password=
payart=Rechnung
Phone=
PostCode=
PREVSTART=21
Profil=true
Profilfound=true
PswdConfirm=171B1704
RabattSatz=20
SaveKkA=0
SearchPremium=[47.2141753,8.364237300000013,"/1/logo-header.png","Burkart AG trilegno","Auw","gl-real-estate-icon",50752],[47.202888, 7.550367,"/51105/Logo_betonexpress.jpg","Betonexpress E. Peri ","Zuchwil","gl-real-estate-icon",51105],[47.57120275,7.63725366622978,"/1/logo-header.png","Baumann + Partner AG ","Riehen","gl-real-estate-icon",26974],[47.1018605,9.062292599999978,"/1/logo-header.png","Atelier Landolt","Näfels","gl-real-estate-icon",52790],[47.492382,7.7828058000000055,"/1/logo-header.png","Aspiring'it GmbH","Waltenschwil","gl-real-estate-icon",52991],[47.4135956,8.391872400000011,"/53158/IMG_4162.png"," Salzdepot Zürich AG","Dietikon","gl-real-estate-icon",53158],[47.3467214,8.727591939459085,"/1/logo-header.png","Adrian Bau und Transport GmbH ","Uster ","gl-real-estate-icon",53552],[47.4905651,8.7055498,"/1/logo-header.png","SOS DACHDECKER GMBH","Winterthur ","gl-real-estate-icon",53628],[47.359486000000004,8.051805150000003,"/1/logo-header.png","Ismajli Fassadenbau","Oberentfelden","gl-real-estate-icon",53747],[47.28708005,8.98282033741667,"/1/logo-header.png","Gübeli Tor- und Metallbau AG","Goldingen ","gl-real-estate-icon",53708],[47.4790632,8.46179,"/1/logo-header.png","Rema-Räumungen","Dielsdorf","gl-real-estate-icon",53507],[47.4905651,8.7055498,"/1/logo-header.png","tps inhaber gabor","winterthur","gl-real-estate-icon",53488],[47.44439505,8.61900628256683,"/1/logo-header.png","TIP TOP Umbau Josifoski","Bassersdorf","gl-real-estate-icon",53311],[47.2090937,7.519862700052494,"/1/logo-header.png","Superelf transport","Solothurn","gl-real-estate-icon",53505],[47.4017116,8.0770916,"/53410/logo_SINISI_hgr_gelb_dach.png","Umbauten Sinisi","Aarau Rohr","gl-real-estate-icon",53410],[46.3455927,8.6074238,"/53454/Maler.jpg","Rachev","Cavergno","gl-real-estate-icon",53454],[46.880894749999996,8.615596660549649,"/1/logo-header.png","Marco Manuel Nunes Fernandes MF Bau","Seedorf","gl-real-estate-icon",53660],[47.3510786,8.703782,"/1/logo-header.png","Maler Danijel Nikolic","Uster","gl-real-estate-icon",52886],[47.43487589999999,8.683520199999975,"/1/logo-header.png","L&A Fenster GnbH","Effretikon ","gl-real-estate-icon",53032],[47.33535295,8.855536644551703,"/53310/3.png","FeuerWerkstatt.Swiss GmbH","Bäretswil ZH","gl-real-estate-icon",53310],[47.3445243,8.734495233453345,"/1/logo-header.png","Ferizi Dani Haustechnik","Uster","gl-real-estate-icon",53199],
sel_branche=0
sel_kanton=
sel_keyword=
sel_ort=
sel_sub_branche=0
sel_typ=
sessionid=Handwerk_ccc74e41-5041-4f18-b255-7c874db2bafd_0
SESSSTARTTIME={ts '2026-04-04 23:29:42'}
SPRACHE=de
STARTROW=41
strCustID=
THEMAID=Suche
timecreated={ts '2026-04-04 23:29:42'}
urltoken=CFID=ccc74e41-5041-4f18-b255-7c874db2bafd&CFTOKEN=0
UserName=---
whitelisted=true

URL Variables:
StartRow=41