Stuff

$query = "SELECT DISTINCT p.*, pd.*
          FROM " . TABLE_PRODUCTS . " p
          LEFT JOIN " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id
          WHERE p.products_id = pd.products_id 
          AND p.products_image = " . '' . "LIMIT 10";