What's new
Power rocker switches and LED indicators, K range...
Read more
Tactile pushbutton switches with large actuator, L...
Read more

Queries

rNews (Records=10, Time=0ms)
SQL = 
SELECT					T01_Ctrl_ModuleListe.PModuleID,
								T01_Ctrl_ModuleListe.FModuleID,
								T01_Ctrl_ModuleVersion.ModuleLib,
								T01_Ctrl_Publication.Comment,
								T01_Ctrl_Image.ClientImg,
								T01_Ctrl_ModuleVersion.LangueID,
								T01_Ctrl_Image.RmtImg
					FROM 		((T01_Ctrl_ModuleListe INNER JOIN (T01_Ctrl_Image INNER JOIN T01_Ctrl_ModuleImage ON T01_Ctrl_Image.ImageID = T01_Ctrl_ModuleImage.ImageID) ON T01_Ctrl_ModuleListe.PModuleID = T01_Ctrl_ModuleImage.PModuleID) INNER JOIN T01_Ctrl_ModuleVersion ON T01_Ctrl_ModuleListe.PModuleID = T01_Ctrl_ModuleVersion.ModuleID) INNER JOIN T01_Ctrl_Publication ON T01_Ctrl_ModuleListe.PModuleID = T01_Ctrl_Publication.PModuleID
				WHERE 			T01_Ctrl_ModuleImage.Type			=		2
					AND 		T01_Ctrl_Publication.LangueID 		=		2
					AND 		T01_Ctrl_ModuleVersion.LangueID		=		2
					AND 		T01_Ctrl_ModuleListe.ArticleTypeID	=		2		
					AND 		T01_Ctrl_ModuleListe.FModuleID		<>		78		
				ORDER BY 		Rnd(T01_Ctrl_ModuleListe.PModuleID)