SELECT products.id AS id FROM ((products LEFT JOIN products_description_ru ON products.id=products_description_ru.product_id AND products_description_ru.shop_id = '93') LEFT JOIN products_prices ON products_prices.product_id = products.id AND products_prices.shop_id = '93') WHERE products.online AND products_prices.online AND products_description_ru.url ='my-fair-lady-20-red-roses-long-stem-80-cm'