Monument Labs interview question

How would you build an infinite scrolling application? How would you join data from one or more MySQL tables? How would you write a program which filters a collection of data and only returning the items matching a specific condition?