In its many embodiments, the present invention provides certain substituted N-aryl and N-heteroaryl piperidine compounds of the Formula (I) : and pharmaceutically acceptable salts thereof, wherein R1, R2, R3, L, R4, L1, Q, R5 and R6 are as defined herein. The novel compounds of the invention, and pharmaceutically acceptable compositions comprising a compound thereof, may be useful as Liver X-β receptor (LXRβ) agonists, and may be useful for treating or preventing pathologies related thereto. Such pathologies include, but are not limited to, inflammatory diseases and diseases characterized by defects in cholesterol and lipid metabolism, such as Alzheimer' s disease.