stison\lib\db\ActiveQuery Object ( [_organisationIdColumn:protected] => `Content`.`OrganisationId` [_withOrganisationEnabled:protected] => 1 [_withUserOrganisationEnabled:protected] => [sql] => [on] => [joinWith] => [select] => Array ( [0] => Content.* ) [selectOption] => [distinct] => [from] => Array ( [0] => Content ) [groupBy] => Array ( [0] => Content.ContentId ) [join] => Array ( [0] => Array ( [0] => LEFT JOIN [1] => Array ( [0] => Books ) [2] => {{Content}}.[[ContentId]] = {{Books}}.[[ContentId]] ) [1] => Array ( [0] => LEFT JOIN [1] => ProductForm [2] => ProductForm.ProductFormId = Books.ProductFormId ) [2] => Array ( [0] => LEFT JOIN [1] => EpubTypes [2] => EpubTypes.EpubTypeId = Books.EpubTypeId ) [3] => Array ( [0] => LEFT JOIN [1] => BookSupply [2] => Array ( [BookSupply.BookId] => yii\db\Expression Object ( [expression] => Books.BookId [params] => Array ( ) ) [BookSupply.SupplierId] => Array ( [0] => 180 ) ) ) [4] => Array ( [0] => LEFT JOIN [1] => BookPrices [2] => BookPrices.BookId = Books.BookId AND BookPrices.SupplierId = BookSupply.SupplierId AND BookPrices.CurrencyCode = :userCurrencyCode AND ( BookPrices.PriceQualifier IS NULL OR BookPrices.PriceQualifier = :priceQualifier ) AND BookPrices.PriceTypeCode IN ( 1,2 ) AND ( BookPrices.DateFrom IS NULL OR BookPrices.DateFrom <= CURRENT_DATE ) AND ( BookPrices.DateTo IS NULL OR BookPrices.DateTo >= CURRENT_DATE ) ) [5] => Array ( [0] => LEFT JOIN [1] => CurrencyCodes [2] => CurrencyCodes.CurrencyCode = BookPrices.CurrencyCode AND CurrencyCodes.CurrencyCode = :userCurrencyCode ) [6] => Array ( [0] => LEFT JOIN [1] => Array ( [0] => ContentPerson ) [2] => {{Content}}.[[ContentId]] = {{ContentPerson}}.[[ContentId]] ) [7] => Array ( [0] => LEFT JOIN [1] => Persons [2] => {{ContentPerson}}.[[PersonId]] = {{Persons}}.[[PersonId]] ) [8] => Array ( [0] => LEFT JOIN [1] => ProductWebsites [2] => {{Content}}.[[ContentId]] = {{ProductWebsites}}.[[ContentId]] ) [9] => Array ( [0] => LEFT JOIN [1] => Prizes [2] => Array ( [0] => and [1] => {{Content}}.[[ContentId]] = {{Prizes}}.[[ContentId]] [2] => PrizeCode NOT IN ('00') ) ) ) [having] => [union] => [withQueries] => [params] => Array ( [:userCurrencyCode] => CAD [:priceQualifier] => 5 ) [queryCacheDuration] => [queryCacheDependency] => [_events:yii\base\Component:private] => Array ( ) [_eventWildcards:yii\base\Component:private] => Array ( ) [_behaviors:yii\base\Component:private] => Array ( ) [where] => Array ( [0] => and [1] => Array ( [Content.PublisherId] => 191 ) [2] => Array ( [ContentPerson.PersonId] => 68408 ) [3] => Array ( [`Content`.`OrganisationId`] => 177 ) [4] => Array ( [`Content`.`OrganisationId`] => 177 ) [5] => Array ( [0] => and [1] => Books.ShowOnWeb = 1 AND Books.Deleted IS NULL AND Books.Archived = 0 [2] => Array ( [Books.PublishingStatus] => Array ( [0] => 0 [1] => 2 [2] => 3 [3] => 4 [4] => 6 [5] => 8 [6] => 9 [7] => 10 [8] => 7 ) ) ) ) [limit] => [offset] => [orderBy] => Array ( [(CASE WHEN ContentType = 1 THEN 0 WHEN ContentType = 2 THEN 1 WHEN ContentType = 5 THEN 2 ELSE 3 END)] => 4 [ProductForm.ProductFormDesc] => 3 [EpubTypes.EpubTypeName] => 4 ) [indexBy] => [emulateExecution] => [modelClass] => stison\models\Content [with] => Array ( [0] => booksExtended [1] => bisacCodes [2] => publisher [3] => imprint ) [asArray] => [multiple] => [primaryModel] => [link] => [via] => [inverseOf] => [viaMap:yii\db\ActiveQuery:private] => [_cacheResult:protected] => Array ( [enable] => 1 [duration] => 60 [dependency] => ) )