select * from sites WHERE url like '%promos-shopping.com%'