SELECT products.id, products.url, products.title, products.description, products.keywords, products.h1, products.content, products.category, products.price, products.pieces, products.out_of_stock, products_categories.url FROM products LEFT JOIN products_categories ON products.category=products_categories.id AND BINARY products_categories.url='mm' WHERE BINARY products.url='dd' AND BINARY products_categories.url='mm' AND products.status='0' AND (products_categories.status='0' OR products_categories.status IS NULL)