daily pastebin goal
45%
SHARE
TWEET

Untitled

a guest Jun 13th, 2018 50 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Query 1 - Vids de boletines de la fecha con palabras en titulo que indican convenio (y categorias concatenadas):
  2.  
  3. SELECT documentos.vid,documentos.texto3,GROUP_CONCAT(artxcat.axc_codcategoria SEPARATOR ', ') FROM documentos JOIN artxcat ON (CONVERT(documentos.vid using 'utf8') = artxcat.axc_codarticulo) where documentos.bd in (10,101,119,227,124,225,352,354,353,83,355,226,114,109,110,210,6822,25) and documentos.fecha1 = "2017-12-15" and (documentos.texto3 like "%Convenio colectivo%" or documentos.texto3 like "%revision salarial%" or documentos.texto3 like "%tablas salariales%" or documentos.texto3 like "%revisió salarial%" or documentos.texto3 like "%conveni col·lectiu%" or documentos.texto3 like "%taules salarials%" ) GROUP BY documentos.vid;
  4.  
  5. Query 2 - Complementario, idem a anterior pero devuelve vids sin categorias:
  6.  
  7. SELECT vid,texto3 FROM documentos where bd in (10,101,119,227,124,225,352,354,353,83,355,226,114,109,110,210,6822,25) and fecha1 = "2017-12-15" and (documentos.texto3 like "%Convenio colectivo%" or documentos.texto3 like "%revision salarial%" or documentos.texto3 like "%tablas salariales%" or documentos.texto3 like "%revisió salarial%" or documentos.texto3 like "%conveni col·lectiu%" or documentos.texto3 like "%taules salarials%" )
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top