TYPO3\CMS\Core\Database\Query\QueryBuilderprototypeobject
connection => protectedTYPO3\CMS\Core\Database\Connectionprototypeobject
_expr => protectedTYPO3\CMS\Core\Database\Query\Expression\ExpressionBuilderprototypeobject
connection => protectedTYPO3\CMS\Core\Database\Connectionprototypeobjectsee above
prepareConnectionCommands => privatearray(empty)
_conn => protectedDoctrine\DBAL\Driver\Mysqli\Connectionprototypeobject
_config => protectedDoctrine\DBAL\Configurationprototypeobject
_attributes => protectedarray(empty)
_eventManager => protectedDoctrine\Common\EventManagerprototypeobject
listeners => privatearray(3 items)
onSchemaColumnDefinition => array(1 item)
00000000687bdd370000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaColumnDefinitionListenerprototypeobject
onSchemaIndexDefinition => array(1 item)
00000000687bdd080000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaIndexDefinitionListenerprototypeobject
onSchemaAlterTable => array(1 item)
00000000687bdd360000000062ebbde8 => TYPO3\CMS\Core\Database\Schema\EventListener\SchemaAlterTableListenerprototypeobject
_schemaManager => protectedNULL
_driver => protectedDoctrine\DBAL\Driver\Mysqli\Driverprototypeobject
defaultFetchMode => protected2 (integer)
logger => protectedNULL
concreteQueryBuilder => protectedDoctrine\DBAL\Query\QueryBuilderprototypeobject
connection => privateTYPO3\CMS\Core\Database\Connectionprototypeobjectsee above
sqlParts => privatearray(10 items)
select => array(16 items)
0 => '`items`.`uid` AS `uid`' (22 chars)
1 => '`items`.`pid` AS `pid`' (22 chars)
2 => '`items`.`tstamp` AS `tstamp`' (28 chars)
3 => '`items`.`title` AS `title`' (26 chars)
4 => '`items`.`subtitle` AS `subtitle`' (32 chars)
5 => '`items`.`nav_title` AS `nav_title`' (34 chars)
6 => '`items`.`abstract` AS `abstract`' (32 chars)
7 => '`items`.`abstract` AS `content`' (31 chars)
8 => '`items`.`media` AS `image`' (26 chars)
9 => '`items`.`lastUpdated` AS `datetime`' (35 chars)
10 => '`items`.`doktype` AS `cobjtype`' (31 chars)
11 => '`items`.`target` AS `target`' (28 chars)
12 => '`items`.`sorting` AS `ranking`' (30 chars)
13 => '`items`.`sorting` AS `sorting`' (30 chars)
14 => ''pages' as ctype' (16 chars)
15 => 'media.uid as mediaUid, media.identifier as mediaPath' (52 chars)
distinct => FALSE
from => array(1 item)
0 => array(2 items)
table => '`pages`' (7 chars)
alias => '`items`' (7 chars)
join => array(2 items)
`items` => array(1 item)
0 => array(4 items)
joinType => 'inner' (5 chars)
joinTable => '`sys_file_reference`' (20 chars)
joinAlias => '`ref`' (5 chars)
joinCondition => '(`items`.`uid` = `ref`.`uid_foreign`) AND (`ref`.`tablenames` = 'pages') AND
(`ref`.`fieldname` = 'media') AND (`ref`.`deleted` = 0) AND (`ref`.`hidden`
= 0) AND (`ref`.`showinpreview` IN (1, 2))' (195 chars)
`ref` => array(1 item)
0 => array(4 items)
joinType => 'left' (4 chars)
joinTable => '`sys_file`' (10 chars)
joinAlias => '`media`' (7 chars)
joinCondition => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (1 items)
parts => privatearray(1 item)max depth
type => private'AND' (3 chars)
set => array(empty)
where => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (7 items)
parts => privatearray(7 items)
0 => '`items`.`tstamp` <= 1713973509' (30 chars)
1 => TYPO3\CMS\Core\Database\Query\Expression\CompositeExpressionprototypeobject (1 items)
parts => privatearray(1 item)
0 => '`doktype` = 3' (13 chars)
type => private'OR' (2 chars)
2 => '`items`.`pid` IN (7595, 9772, 12409, 12404)' (43 chars)
3 => '`items`.`hidden` IN (0)' (23 chars)
4 => '`items`.`deleted` IN (0)' (24 chars)
5 => '`items`.`hidden` IN (0)' (23 chars)
6 => '`items`.`deleted` IN (0)' (24 chars)
type => private'AND' (3 chars)
groupBy => array(empty)
having => NULL
orderBy => array(empty)
values => array(empty)
sql => privateNULL
params => privatearray(empty)
paramTypes => privatearray(empty)
type => private0 (integer)
state => private0 (integer)
firstResult => private0 (integer)
maxResults => privateNULL
boundCounter => private0 (integer)
restrictionContainer => protectedTYPO3\CMS\Core\Database\Query\Restriction\DefaultRestrictionContainerprototypeobject
defaultRestrictionTypes => protectedarray(4 items)
0 => 'TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction' (60 chars)
1 => 'TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestriction' (59 chars)
2 => 'TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestriction' (62 chars)
3 => 'TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestriction' (60 chars)
restrictions => protectedarray(5 items)
TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestriction => TYPO3\CMS\Core\Database\Query\Restriction\DeletedRestrictionprototypeobject
TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestriction => TYPO3\CMS\Core\Database\Query\Restriction\HiddenRestrictionprototypeobject
TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestriction => TYPO3\CMS\Core\Database\Query\Restriction\StartTimeRestrictionprototypeobject
accessTimeStamp => protected1713973500 (integer)
TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestriction => TYPO3\CMS\Core\Database\Query\Restriction\EndTimeRestrictionprototypeobject
accessTimeStamp => protected1713973500 (integer)
Bitmotion\MarketingAutomation\Persona\PersonaRestriction => Bitmotion\MarketingAutomation\Persona\PersonaRestrictionsingletonobject
sqlFieldTemplate => private'CREATE TABLE %s ( `%s` varchar(100) DEFAULT '' NOT NULL);' (57 chars)
tcaFieldTemplate => privatearray(2 items)
label => 'LLL:EXT:marketing_automation/Resources/Private/Language/locallang_tca.xlf:tx
_marketingautomation_persona_restriction.label' (122 chars)
config => array(6 items)
type => 'select' (6 chars)
renderType => 'selectMultipleSideBySide' (24 chars)
exclusiveKeys => '-1' (2 chars)
foreign_table => 'tx_marketingautomation_persona' (30 chars)
foreign_table_where => 'ORDER BY tx_marketingautomation_persona.title' (45 chars)
items => array(3 items)
0 => array(2 items)max depth
1 => array(2 items)max depth
2 => array(2 items)max depth
persona => privateBitmotion\MarketingAutomation\Persona\Personaprototypeobject
id => protected0 (integer)
language => protected0 (integer)
enforcedRestrictions => protectedarray(1 item)
Bitmotion\MarketingAutomation\Persona\PersonaRestriction => Bitmotion\MarketingAutomation\Persona\PersonaRestrictionsingletonobjectsee above
additionalRestrictions => protectedarray(1 item)
Bitmotion\MarketingAutomation\Persona\PersonaRestriction => array(empty)
restrictionsAppliedInJoinCondition => privatearray(1 item)
0 => 'media' (5 chars)