Unithèque, librairie universitaire et technique pour étudiants et professionnels.
SELECT IND.ID_Indexation, INL_Ordre, IND_Titre, IND_Lien, IND_SerialParam FROM indexation IND, indexation_linkmodule INL WHERE INL.ID_Indexation = IND.ID_Indexation AND INL_Identifiant = '' AND ID_Module = 'K' ORDER BY INL_Ordre |
Mysql Error: |
SELECT IND.ID_Indexation , INL_Ordre , IND_Titre , IND_Lien , IND_SerialParam FROM indexation IND , indexation_linkmodule INL WHERE INL.ID_Indexation = IND.ID_Indexation AND INL_Identifiant = '' AND ID_Module = 'K' ORDER BY INL_Ordre |
SELECT ART_Titre, ART.ID_TypeArticle, TYA_Libelle, ART.ID_TypeArticle, ART_Annee, ART.ID_Article, TYA_Libelle, ART_Auteur, ART_Editeur, ART_Collection, ART_Descriptif, ART_SousTitre FROM architecture_article ARA, article ART, declinaison_article DEA, article_photo ARP, type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND (DEA.DAR_StockInternet+DEA.DAR_StockLibInternet > 0) AND ART_Annee < '2024/12' AND ART_4Couverture != '' AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY ART_AnneeParution DESC, ART_MoisParution DESC, ART_TimeStampDiffusion DESC Limit 0,20 |
Mysql Error: |
SELECT ART_Titre , ART.ID_TypeArticle , TYA_Libelle , ART.ID_TypeArticle , ART_Annee , ART.ID_Article , TYA_Libelle , ART_Auteur , ART_Editeur , ART_Collection , ART_Descriptif , ART_SousTitre FROM architecture_article ARA , article ART , declinaison_article DEA , article_photo ARP , type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND ( DEA.DAR_StockInternet+DEA.DAR_StockLibInternet > 0 ) AND ART_Annee < '2024/12' AND ART_4Couverture != '' AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY ART_AnneeParution DESC , ART_MoisParution DESC , ART_TimeStampDiffusion DESC Limit 0 , 20 |
SELECT ART_Titre, ART.ID_TypeArticle, ART_Annee, ART.ID_Article, TYA_Libelle, ART_Auteur, ART_Editeur, ART_Collection, ART_Descriptif, ART_SousTitre FROM architecture_article ARA, article ART, declinaison_article DEA, article_photo ARP, type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND (DEA.ID_Stock = '0') AND ART_Annee < '2025/01' AND ART_4Couverture != '' AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY ART_AnneeParution DESC, ART_MoisParution DESC, ART_TimeStampDiffusion DESC Limit 0,8 |
Mysql Error: |
SELECT ART_Titre , ART.ID_TypeArticle , ART_Annee , ART.ID_Article , TYA_Libelle , ART_Auteur , ART_Editeur , ART_Collection , ART_Descriptif , ART_SousTitre FROM architecture_article ARA , article ART , declinaison_article DEA , article_photo ARP , type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND ( DEA.ID_Stock = '0' ) AND ART_Annee < '2025/01' AND ART_4Couverture != '' AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY ART_AnneeParution DESC , ART_MoisParution DESC , ART_TimeStampDiffusion DESC Limit 0 , 8 |
SELECT ART_Titre, ART.ID_TypeArticle, TYA_Libelle, ART_Annee, ART.ID_Article, ART_Auteur, ART_Editeur, ART_Collection, ART_Descriptif, ART_SousTitre FROM architecture_article ARA, article ART, declinaison_article DEA, type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ART.ID_Article = DEA.ID_Article AND ID_Stock != 0 AND ID_Stock != 6 AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY DAR_NbVente DESC LIMIT 0, 10 |
Mysql Error: |
SELECT ART_Titre , ART.ID_TypeArticle , TYA_Libelle , ART_Annee , ART.ID_Article , ART_Auteur , ART_Editeur , ART_Collection , ART_Descriptif , ART_SousTitre FROM architecture_article ARA , article ART , declinaison_article DEA , type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ART.ID_Article = DEA.ID_Article AND ID_Stock != 0 AND ID_Stock != 6 AND ID_Architecture like 'BF%' GROUP BY ART.ID_Article ORDER BY DAR_NbVente DESC LIMIT 0 , 10 |
SELECT distinct(EDI.ID_Editorial) FROM editorial EDI, edito_gabarits EGA, architecture_editorial ARE, workcycle_editorial WER, annuaire_ea AEA WHERE AEA.ID_AnnuaireEA = WER.ID_AnnuaireEA AND WER.ID_Editorial = EDI.ID_Editorial AND ARE.ID_Editorial = EDI.ID_Editorial AND EDI.ID_EdGabarit = EGA.ID_EdGabarit AND (ID_WorkflowEtat = '7') AND ARE.ID_Architecture not like 'DACB%' AND EDI_Rubrique like'BF%' ORDER BY EDI_DateModification DESC LIMIT 0, 4 |
Mysql Error: |
SELECT distinct ( EDI.ID_Editorial ) FROM editorial EDI , edito_gabarits EGA , architecture_editorial ARE , workcycle_editorial WER , annuaire_ea AEA WHERE AEA.ID_AnnuaireEA = WER.ID_AnnuaireEA AND WER.ID_Editorial = EDI.ID_Editorial AND ARE.ID_Editorial = EDI.ID_Editorial AND EDI.ID_EdGabarit = EGA.ID_EdGabarit AND ( ID_WorkflowEtat = '7' ) AND ARE.ID_Architecture not like 'DACB%' AND EDI_Rubrique like'BF%' ORDER BY EDI_DateModification DESC LIMIT 0 , 4 |
SELECT ART_Titre, ART.ID_TypeArticle, TYA_Libelle, ART_Annee, ART.ID_Article, ART_Auteur, ART_Editeur, ART_Collection, ART_Descriptif, ART_SousTitre FROM architecture_article ARA, article ART, declinaison_article DEA, avis_clients AVC, type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND AVC.ID_Declinaison = DEA.ID_Declinaison AND AVC_Mktime >= '1700607600' AND ART.ID_Article = DEA.ID_Article AND DAR_NoteGlobale >= 4 AND DAR_NbAvis >= 2 AND ID_Architecture like 'BF%' GROUP BY DEA.ID_Declinaison ORDER BY DAR_NoteGlobale DESC, AVC_Mktime DESC LIMIT 0, 10 |
Mysql Error: |
SELECT ART_Titre , ART.ID_TypeArticle , TYA_Libelle , ART_Annee , ART.ID_Article , ART_Auteur , ART_Editeur , ART_Collection , ART_Descriptif , ART_SousTitre FROM architecture_article ARA , article ART , declinaison_article DEA , avis_clients AVC , type_article TYA WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND AVC.ID_Declinaison = DEA.ID_Declinaison AND AVC_Mktime >= '1700607600' AND ART.ID_Article = DEA.ID_Article AND DAR_NoteGlobale >= 4 AND DAR_NbAvis >= 2 AND ID_Architecture like 'BF%' GROUP BY DEA.ID_Declinaison ORDER BY DAR_NoteGlobale DESC , AVC_Mktime DESC LIMIT 0 , 10 |
SELECT * FROM editorial EDI, edito_gabarits EGA, architecture_editorial ARE, workcycle_editorial WER, annuaire_ea AEA WHERE AEA.ID_AnnuaireEA = WER.ID_AnnuaireEA AND WER.ID_Editorial = EDI.ID_Editorial AND ARE.ID_Editorial = EDI.ID_Editorial AND EDI.ID_EdGabarit = EGA.ID_EdGabarit AND (ID_WorkflowEtat = '7') AND ARE.ID_Architecture like 'DACB%' AND EDI_Rubrique like'BF%' AND ARE.ID_Architecture NOT LIKE 'DACCA' ORDER BY EDI_DateModification LIMIT 0, 20 |
Mysql Error: |
SELECT * FROM editorial EDI , edito_gabarits EGA , architecture_editorial ARE , workcycle_editorial WER , annuaire_ea AEA WHERE AEA.ID_AnnuaireEA = WER.ID_AnnuaireEA AND WER.ID_Editorial = EDI.ID_Editorial AND ARE.ID_Editorial = EDI.ID_Editorial AND EDI.ID_EdGabarit = EGA.ID_EdGabarit AND ( ID_WorkflowEtat = '7' ) AND ARE.ID_Architecture like 'DACB%' AND EDI_Rubrique like'BF%' AND ARE.ID_Architecture NOT LIKE 'DACCA' ORDER BY EDI_DateModification LIMIT 0 , 20 |
SELECT ART_Titre, ART.ID_TypeArticle, TYA_Libelle, ART_Annee, ART.ID_Article, ART_Auteur, ART_Editeur, ART_Collection, ART_Descriptif, ART_SousTitre FROM architecture_article ARA, article ART, declinaison_article DEA, type_article TYA, article_photo ARP WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND (DEA.ID_Stock = '1' OR DEA.ID_Stock = '2' OR DEA.ID_Stock = '5' OR DEA.ID_Stock = '0') AND (DAR_PrixReduit > 0 OR DAR_Reduction > 5 OR DAR_PrixEuroLancement > 0) AND ID_Architecture like 'BF%' GROUP BY DEA.ID_Declinaison ORDER BY ART_AnneeParution DESC, ART_MoisParution DESC, ART_TimeStampDiffusion DESC Limit 0,10 |
Mysql Error: |
SELECT ART_Titre , ART.ID_TypeArticle , TYA_Libelle , ART_Annee , ART.ID_Article , ART_Auteur , ART_Editeur , ART_Collection , ART_Descriptif , ART_SousTitre FROM architecture_article ARA , article ART , declinaison_article DEA , type_article TYA , article_photo ARP WHERE ARA.ID_Article = DEA.ID_Article AND TYA.ID_TypeArticle = ART.ID_TypeArticle AND ARP.ID_Article = ART.ID_Article AND DEA.ID_Article = ART.ID_Article AND ( DEA.ID_Stock = '1' OR DEA.ID_Stock = '2' OR DEA.ID_Stock = '5' OR DEA.ID_Stock = '0' ) AND ( DAR_PrixReduit > 0 OR DAR_Reduction > 5 OR DAR_PrixEuroLancement > 0 ) AND ID_Architecture like 'BF%' GROUP BY DEA.ID_Declinaison ORDER BY ART_AnneeParution DESC , ART_MoisParution DESC , ART_TimeStampDiffusion DESC Limit 0 , 10 |