SELECT SQL_CALC_FOUND_ROWS `products_stock`.`products_id`,`products_stock`.`products_stock_attributes`,`products_stock`.`products_stock_quantity`,`products`.`manufacturers_id`,`products_description`.`products_name`
         FROM  `products_stock`
        LEFT JOIN  `products` ON  `products_stock`.`products_id` =  `products`.`products_id`
        LEFT JOIN  `products_description` ON  `products_stock`.`products_id` =  `products_description`.`products_id`
        LEFT JOIN `products_to_categories` ON `products_stock`.`products_id` = `products_to_categories`.`products_id`

        WHERE `products_stock`.`products_stock_quantity` >=3 AND `products`.`products_status` = 1
        AND ISNULL(`products`.`products_image`) = FALSE AND `products`.`products_image` != ""

        AND EXISTS(

            SELECT * FROM `allegro` WHERE `products_stock`.`products_id` = `allegro`.`product_id`
            AND `allegro`.`attributes` =  `products_stock`.`products_stock_attributes`

        ) = FALSE