object(PDOStatement)#371 (1) {
  ["queryString"]=>
  string(1815) "SELECT c.ID as ClientID, c.url as ClientUrl, c.Name as ClientName, ci.Name as CityName, ci.NormalizedName as CityNormalizeName, cc.Image as ClientImage, l.ListingTypeID,
        IF(NOT l.is_member AND l.ClientID IS NOT NULL AND IF(ilp.ID IS NULL, (i.PaymentStatusID = '2' OR (i.EuroAmount = '0' AND i.Amount = '0') ), (ilp.PaymentStatusID = '2' OR (ilp.EuroAmount = '0' AND ilp.Amount = '0') )), 1, 0) free,
        IF(l.DateFrom IS NOT NULL AND l.DateTo IS NOT NULL, IF(l.DateFrom <= CURDATE() AND l.DateTo >= CURDATE(), 0, 1), IF(l.DateFrom IS NOT NULL, IF(l.DateFrom <= CURDATE(), 0, 1), IF(l.DateTo IS NOT NULL, IF(l.DateTo >= CURDATE(), 0, 1), 1))) expired, r.id review_id FROM pp_listing_details ld
        INNER JOIN pp_clients c ON ld.ClientID = c.ID
        LEFT JOIN pp_invoices i ON i.ClientID = c.ID
        LEFT JOIN pp_invoices ilp ON ilp.ID = i.ParentID
        INNER JOIN pp_listing l ON l.InvoiceID = i.ID
        INNER JOIN pp_cities ci ON c.CityID = ci.ID
        INNER JOIN pp_countries co ON co.ID = ci.CountryID
        LEFT JOIN pp_invoices pi ON i.ParentID = pi.ID
        LEFT JOIN pp_reviews r ON r.client_id = c.ID
        LEFT JOIN (
            SELECT cn2.ClientID, MAX(cn2.published_at) AS published_at
            FROM pp_x_clients_newsletters cn2
            GROUP BY cn2.ClientID
        ) cn ON cn.ClientID = c.ID
        INNER JOIN pp_x_clients_categories cc ON cc.ClientID = c.ID 
        WHERE l.ListingTypeID > 1 AND l.Ignore != '1' AND (ld.StatusID != '4' OR ld.StatusID is null) AND c.isCustomer = '1'
        
        
        AND cc.CategoryID IN (619)
        AND (ci.NormalizedName = 'dubai' OR co.NormalizedName = 'dubai')
     GROUP BY ClientID
        ORDER BY free OR expired, NOT (free OR expired) AND ListingTypeID>2 DESC, ld.Name ASC, c.ID
        LIMIT 0, 50
    "
}
array(3) {
  [0]=>
  string(5) "70100"
  [1]=>
  int(1317)
  [2]=>
  string(31) "Query execution was interrupted"
}
Result Error in executing Statement [195f49eb699e481829b04675148a5933].