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] => 9623
)
[2] => Array
(
[ContentPerson.PersonId] => 27669
)
[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] =>
)
)