SELECT * FROM objects_content INNER JOIN objects ON objects_content.id_object=objects.id INNER JOIN objects_categories ON objects_content.id_object=objects_categories.id_object INNER JOIN images ON objects_content.id_object=images.id_object WHERE objects_categories.id_categories='28' AND objects.visible='Y' ORDER BY objects.enter_date DESC LIMIT 0, 10










1 2 3 > >>