|
|
SELECT c.id AS config_id,c.firma AS config_firma,c.beratungsthema AS config_beratungsthema,c.beratungsfeld AS firma_beratungsfeld,c.chatname AS firma_chatname,c.services AS config_services,c.plattformen AS config_plattformen,c.anfrage_addr AS config_anfrage_addr,c.chatroom_permanent AS config_chatroom_permanent,c.chatroom_gast AS config_chatroom_gast,c.chatroom_max_user AS config_chatroom_max_user,c.modulrechte AS config_modulrechte,f.id AS firma_id,f.name AS firma_name,f.name2 AS firma_name2,f.keywords AS firma_keywords,f.kurztext AS firma_shorttext,f.beratel AS firma_ber_fon,f.teltext AS firma_ber_fon_open,count(t.firma) AS firma_termine FROM config c ,firma f LEFT JOIN chattermin t ON t.von>"1280616611" AND t.firma=c.firma WHERE c.plattformen & 2 AND f.id=c.firma AND c.services & 4 GROUP BY t.firma ORDER BY (c.modulrechte & BINARY("0000000000000001") AND BINARY(c.modulrechte)) DESC,f.name LIMIT 0,20
|
|
| Es wurde leider keine Beratungseinrichtung gefunden die z.Z. freie Chat-Beratungstermine zur Verfügung hat. |
|
|
|
|