qr linux

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

Q&A about the site for members of the workforce navigating the professional setting

DECLARE @numero_rubrique int=45
-- Numero de la rubrique parente apres la racine 36 = C++
DECLARE @numero_secteur int=36 
SELECT
a.tags,
a.ViewCount,
a.Id,
'' AS id_article,
'' AS surtitre,
a.Title As titre,
'' AS soustitre,
@numero_rubrique AS id_rubrique,
'' AS descriptif,
'' AS chapo,
'<html>'+a.Body+'<br>Answer:</br>'+b.Body+'</html>' AS texte,
'' AS ps,
getdate() AS 'date',
'prepa' AS statut,
@numero_secteur AS id_secteur,
getdate() AS maj,
'oui' AS export,
getdate() AS date_redac,
'0' AS visites,
'0' AS referers,
'0' AS popularite,
'non' AS accepter_forum,
getdate() AS date_modif,
'en' AS lang,
'non' AS langue_choisie,
'0' AS id_trad,
'NULL' AS extra,
'0' AS id_version,
'' AS nom_site,'' AS url_site,
'' AS virtuel
FROM Posts a
INNER JOIN Posts b
ON a.AcceptedAnswerId=b.Id
WHERE a.tags like '%bash%' AND a.tags like '%linux%'
ORDER by a.ViewCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results