DC resistivity of quantum critical, charge density wave states from gauge-gravity duality