O-ó, valamit nagyon eltoltunk!
Request: 
Array
(
)
Query: 
SELECT
    `webshop_products`.`id`,
    `webshop_products`.`name` AS `name`,
    `webshop_products`.`smalltitle` AS `stitle`,
    `webshop_products`.`price`,
    `webshop_products`.`sale`,
    `webshop_products`.`sale_price`,
    `webshop_products`.`sale_end` AS `senddaate`,
    `webshop_products`.`city_id`,
    `webshop_products`.`vanajandek`,
    `webshop_products`.`exclusive`,
    `webshop_products`.`articleid`,
    `webshop_products`.`dbto`,
    `webshop_products`.`buyedcount`,
    `webshop_products`.`newsletter_text`,
    `webshop_products`.`seo_keyword`,
    `webshop_products`.`type`,
    `webshop_categories`.`id` AS `category_id`,
    `webshop_categories`.`name` AS `catname`,
    `datasheet`.`title` AS `provider_name`,
    `datasheet`.`address`,
    `diamond_hunter`.`startDate`,
    `diamond_hunter`.`endDate`,
    `diamond_hunter`.`diamond`,
    `diamond_hunter`.`showOnFront`,
    `wp_daily_deal`.`date` AS `daily_date`,
    `wp_daily_deal`.`source` AS `daily_source_id`,
    `eternal_id_wp_rel`.`eternal_id`
FROM
    `webshop_products`
INNER JOIN `webshop_product_categories` ON `webshop_products`.`id` = `webshop_product_categories`.`wp_id`
INNER JOIN `webshop_categories` ON `webshop_categories`.`id` = `webshop_product_categories`.`wc_id`
INNER JOIN `datasheet` ON `datasheet`.`id` = `webshop_products`.`datasheet_id`
INNER JOIN `eternal_id_wp_rel` ON `eternal_id_wp_rel`.`wp_id` = `webshop_products`.`id`
LEFT JOIN `diamond_hunter` ON `webshop_products`.`id` = `diamond_hunter`.`productId`
LEFT JOIN `wp_daily_deal` ON `wp_daily_deal`.`wp_id` = `webshop_products`.`id`
WHERE
     ( `webshop_products`.`active` = :_1_ AND `webshop_products`.`sale_start` <= NOW() AND `webshop_products`.`sale_end` >= NOW() AND `webshop_products`.`erv_end` >= NOW() AND `datasheet`.`active` = 1 AND IF(`webshop_products`.`dbto` != 0, IF(`webshop_products`.`buyedcount` < `webshop_products`.`dbto`, 1, 0), 1) = 1 ) 
    AND  ( `webshop_product_categories`.`wc_id` IN (:_2_, :_3_)  ) 
    AND  ( `wp_daily_deal`.`date` IS NULL ) 
GROUP BY
    `webshop_products`.`id`
LIMIT 72Bind: 
"1","322","322"Array
(
)
DD\Products\Lists\FilteredProductList Object
(
    [defaultModifiersAdded:protected] => 
    [table:protected] => webshop_products
    [innerJoin:protected] => Array
        (
            [webshop_product_categories] => Array
                (
                    [webshop_products] => webshop_products.id = webshop_product_categories.wp_id
                )

            [webshop_categories] => Array
                (
                    [webshop_product_categories] => webshop_categories.id = webshop_product_categories.wc_id
                )

            [webshop_products_labels] => Array
                (
                    [webshop_products] => webshop_products.id = webshop_products_labels.productid
                )

            [webshop_labels] => Array
                (
                    [webshop_products_labels] => webshop_products_labels.labelid = webshop_labels.id
                )

            [datasheet] => Array
                (
                    [webshop_products] => datasheet.id = webshop_products.datasheet_id
                )

            [eternal_id_wp_rel] => Array
                (
                    [webshop_products] => eternal_id_wp_rel.wp_id = webshop_products.id
                )

            [wu_favourites] => Array
                (
                    [eternal_id_wp_rel] => wu_favourites.eternal_id = eternal_id_wp_rel.eternal_id
                )

        )

    [leftJoin:protected] => Array
        (
            [diamond_hunter] => Array
                (
                    [webshop_products] => webshop_products.id = diamond_hunter.productId
                )

            [wp_daily_deal] => Array
                (
                    [webshop_products] => wp_daily_deal.wp_id = webshop_products.id
                )

        )

    [fields:protected] => Array
        (
            [webshop_products] => Array
                (
                    [0] => id
                    [1] => name AS name
                    [2] => smalltitle AS stitle
                    [3] => price
                    [4] => sale
                    [5] => sale_price
                    [6] => sale_end AS senddaate
                    [7] => city_id
                    [8] => vanajandek
                    [9] => exclusive
                    [10] => articleid
                    [11] => dbto
                    [12] => buyedcount
                    [13] => newsletter_text
                    [14] => seo_keyword
                    [15] => type
                )

            [webshop_categories] => Array
                (
                    [0] => id AS category_id
                    [1] => name AS catname
                )

            [datasheet] => Array
                (
                    [0] => title AS provider_name
                    [1] => address
                )

            [diamond_hunter] => Array
                (
                    [0] => startDate
                    [1] => endDate
                    [2] => diamond
                    [3] => showOnFront
                )

            [wp_daily_deal] => Array
                (
                    [0] => date as daily_date
                    [1] => source as daily_source_id
                )

            [eternal_id_wp_rel] => Array
                (
                    [0] => eternal_id
                )

        )

    [bodyData:protected] => 
    [position:protected] => 
    [rawMode:protected] => 
    [headerData:protected] => Array
        (
            [id] => Array
                (
                    [displayedName] => id
                    [formatter] => 
                )

            [name] => Array
                (
                    [displayedName] => name
                    [formatter] => 
                )

            [name_short] => Array
                (
                    [displayedName] => name_short
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$b] => 
                                )

                        )

                )

            [name_tile_short] => Array
                (
                    [displayedName] => name_tile_short
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$b] => 
                                )

                        )

                )

            [stitle] => Array
                (
                    [displayedName] => stitle
                    [formatter] => 
                )

            [type] => Array
                (
                    [displayedName] => type
                    [formatter] => 
                )

            [seo_keyword] => Array
                (
                    [displayedName] => seo_keyword
                    [formatter] => 
                )

            [newsletter_text] => Array
                (
                    [displayedName] => newsletter_text
                    [formatter] => 
                )

            [price] => Array
                (
                    [displayedName] => price
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$b] => 
                                )

                        )

                )

            [sale] => Array
                (
                    [displayedName] => sale
                    [formatter] => 
                )

            [sale_price] => Array
                (
                    [displayedName] => sale_price
                    [formatter] => 
                )

            [senddaate] => Array
                (
                    [displayedName] => senddaate
                    [formatter] => 
                )

            [city_id] => Array
                (
                    [displayedName] => city_id
                    [formatter] => 
                )

            [articleid] => Array
                (
                    [displayedName] => articleid
                    [formatter] => 
                )

            [dbto] => Array
                (
                    [displayedName] => dbto
                    [formatter] => 
                )

            [buyedcount] => Array
                (
                    [displayedName] => buyedcount
                    [formatter] => 
                )

            [vanajandek] => Array
                (
                    [displayedName] => vanajandek
                    [formatter] => 
                )

            [exclusive] => Array
                (
                    [displayedName] => exclusive
                    [formatter] => 
                )

            [category_id] => Array
                (
                    [displayedName] => category_id
                    [formatter] => 
                )

            [eternal_id] => Array
                (
                    [displayedName] => eternal_id
                    [formatter] => 
                )

            [szazk] => Array
                (
                    [displayedName] => szazk
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [szazk2] => Array
                (
                    [displayedName] => szazk2
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [product_url] => Array
                (
                    [displayedName] => product_url
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [image_url] => Array
                (
                    [displayedName] => image_url
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [image_path] => Array
                (
                    [displayedName] => image_path
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [boxstyle] => Array
                (
                    [displayedName] => boxstyle
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

            [address] => Array
                (
                    [displayedName] => address
                    [formatter] => 
                )

            [provider_name] => Array
                (
                    [displayedName] => provider_name
                    [formatter] => 
                )

            [startDate] => Array
                (
                    [displayedName] => startDate
                    [formatter] => 
                )

            [endDate] => Array
                (
                    [displayedName] => endDate
                    [formatter] => 
                )

            [diamond] => Array
                (
                    [displayedName] => diamond
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$b] => 
                                )

                        )

                )

            [showOnFront] => Array
                (
                    [displayedName] => showOnFront
                    [formatter] => 
                )

            [ishighlighted] => Array
                (
                    [displayedName] => ishighlighted
                    [formatter] => Closure Object
                        (
                            [this] => DD\Products\Lists\FilteredProductList Object
 *RECURSION*
                            [parameter] => Array
                                (
                                    [$a] => 
                                    [$d] => 
                                )

                        )

                )

        )

    [modifierRegistry:protected] => DD\DataCollection\ConfigurableModifierRegistry Object
        (
            [globalConfigData:protected] => Array
                (
                    [offsetCount] => 72
                    [offsetStart] => 0
                    [category_path] => DD\Products\Category\Path Object
                        (
                            [path:protected] => Array
                                (
                                    [0] => 58
                                    [1] => 59
                                    [2] => 113
                                    [3] => 322
                                )

                            [cursor:protected] => 4
                            [validPath:protected] => 1
                        )

                    [category_id] => 322
                    [displayedItemCount] => 72
                )

            [specificConfigData:protected] => Array
                (
                )

            [needReconfigure:protected] => 
            [dominantRelations:protected] => Array
                (
                    [DD\Products\Lists\Modifier\PhraseFilter] => Array
                        (
                            [DD\Products\Lists\Modifier\LabelFilter] => DD\Products\Lists\Modifier\LabelFilter
                        )

                    [DD\Products\Lists\Modifier\DailyDealFilter] => Array
                        (
                            [DD\Products\Lists\Modifier\HighlightedProductFilter] => DD\Products\Lists\Modifier\HighlightedProductFilter
                        )

                )

            [modifiers:protected] => Array
                (
                    [DD\Products\Lists\Modifier\ActiveProductFilter] => DD\Products\Lists\Modifier\ActiveProductFilter Object
                        (
                            [active:protected] => 1
                            [sqlFragment:protected] => DD\DataCollection\SQLFragment Object
                                (
                                    [requiredTables:protected] => Array
                                        (
                                            [0] => webshop_products
                                            [1] => datasheet
                                        )

                                    [whereConditions:protected] => Array
                                        (
                                            [0] => webshop_products.active = ?
                                            [1] => webshop_products.sale_start <= NOW()
                                            [2] => webshop_products.sale_end >= NOW()
                                            [3] => webshop_products.erv_end >= NOW()
                                            [4] => datasheet.active = 1
                                            [5] => IF(webshop_products.dbto != 0, IF(webshop_products.buyedcount < webshop_products.dbto, 1, 0), 1) = 1
                                        )

                                    [whereData:protected] => Array
                                        (
                                            [0] => 1
                                            [1] => 
                                            [2] => 
                                            [3] => 
                                            [4] => 
                                            [5] => 
                                        )

                                    [limit:protected] => Array
                                        (
                                        )

                                    [mergeOperator:protected] => AND
                                    [orderBy:protected] => Array
                                        (
                                        )

                                    [name:protected] => DD\Products\Lists\Modifier\ActiveProductFilter
                                )

                            [name:protected] => DD\Products\Lists\Modifier\ActiveProductFilter
                        )

                    [DD\Products\Lists\Modifier\CategoryFilter] => DD\Products\Lists\Modifier\CategoryFilter Object
                        (
                            [categoryIDList:protected] => Array
                                (
                                    [0] => 322
                                    [1] => 322
                                )

                            [path:protected] => DD\Products\Category\Path Object
                                (
                                    [path:protected] => Array
                                        (
                                            [0] => 58
                                            [1] => 59
                                            [2] => 113
                                            [3] => 322
                                        )

                                    [cursor:protected] => 4
                                    [validPath:protected] => 1
                                )

                            [field:protected] => wc_id
                            [param:protected] => Array
                                (
                                    [0] => 322
                                    [1] => 322
                                )

                            [relation:protected] =>  = 
                            [table:protected] => webshop_product_categories
                            [active:protected] => 1
                            [sqlFragment:protected] => DD\DataCollection\SQLFragment Object
                                (
                                    [requiredTables:protected] => Array
                                        (
                                            [0] => webshop_product_categories
                                        )

                                    [whereConditions:protected] => Array
                                        (
                                            [0] => `webshop_product_categories`.`wc_id` IN (?, ?) 
                                        )

                                    [whereData:protected] => Array
                                        (
                                            [0] => 322
                                            [1] => 322
                                        )

                                    [limit:protected] => Array
                                        (
                                        )

                                    [mergeOperator:protected] => AND
                                    [orderBy:protected] => Array
                                        (
                                        )

                                    [name:protected] => DD\Products\Lists\Modifier\CategoryFilter
                                )

                            [name:protected] => DD\Products\Lists\Modifier\CategoryFilter
                        )

                    [DD\Products\Lists\Modifier\CityFilter] => DD\Products\Lists\Modifier\CityFilter Object
                        (
                            [cityID:protected] => 
                            [field:protected] => 
                            [param:protected] => 
                            [relation:protected] => =
                            [table:protected] => 
                            [active:protected] => 0
                            [sqlFragment:protected] => 
                            [name:protected] => DD\Products\Lists\Modifier\CityFilter
                        )

                    [DD\Products\Lists\Modifier\LabelFilter] => DD\Products\Lists\Modifier\LabelFilter Object
                        (
                            [labelID:protected] => 
                            [field:protected] => 
                            [param:protected] => 
                            [relation:protected] => =
                            [table:protected] => 
                            [active:protected] => 
                            [sqlFragment:protected] => 
                            [name:protected] => DD\Products\Lists\Modifier\LabelFilter
                        )

                    [DD\Products\Lists\Modifier\PhraseFilter] => DD\Products\Lists\Modifier\PhraseFilter Object
                        (
                            [phrase:protected] => 
                            [requiredFields:protected] => Array
                                (
                                    [webshop_labels] => name
                                    [webshop_products] => Array
                                        (
                                            [0] => id
                                            [1] => smalltitle
                                        )

                                    [datasheet] => title
                                )

                            [active:protected] => 
                            [sqlFragment:protected] => 
                            [name:protected] => DD\Products\Lists\Modifier\PhraseFilter
                        )

                    [DD\Products\Lists\Modifier\DisplayOrderModifier] => DD\Products\Lists\Modifier\DisplayOrderModifier Object
                        (
                            [active:protected] => 
                            [sqlFragment:protected] => 
                            [name:protected] => DD\Products\Lists\Modifier\DisplayOrderModifier
                        )

                    [DD\Products\Lists\Modifier\HighlightedProductFilter] => DD\Products\Lists\Modifier\HighlightedProductFilter Object
                        (
                            [field:protected] => 
                            [param:protected] => 
                            [relation:protected] => =
                            [table:protected] => 
                            [active:protected] => 
                            [sqlFragment:protected] => 
                            [name:protected] => DD\Products\Lists\Modifier\HighlightedProductFilter
                        )

                    [DD\Products\Lists\Modifier\DailyDealFilter] => DD\Products\Lists\Modifier\DailyDealFilter Object
                        (
                            [field:protected] => date
                            [param:protected] => 
                            [relation:protected] =>  IS NULL
                            [table:protected] => wp_daily_deal
                            [active:protected] => 1
                            [sqlFragment:protected] => DD\DataCollection\SQLFragment Object
                                (
                                    [requiredTables:protected] => Array
                                        (
                                            [0] => wp_daily_deal
                                        )

                                    [whereConditions:protected] => Array
                                        (
                                            [0] => `wp_daily_deal`.`date` IS NULL
                                        )

                                    [whereData:protected] => Array
                                        (
                                        )

                                    [limit:protected] => Array
                                        (
                                        )

                                    [mergeOperator:protected] => AND
                                    [orderBy:protected] => Array
                                        (
                                        )

                                    [name:protected] => DD\Products\Lists\Modifier\DailyDealFilter
                                )

                            [name:protected] => DD\Products\Lists\Modifier\DailyDealFilter
                        )

                )

        )

    [productFilterConfig:protected] => DD\Products\Lists\ProductFilterConfig Object
        (
            [config:protected] => Array
                (
                    [offsetCount] => 72
                    [offsetStart] => 0
                    [category_path] => DD\Products\Category\Path Object
                        (
                            [path:protected] => Array
                                (
                                    [0] => 58
                                    [1] => 59
                                    [2] => 113
                                    [3] => 322
                                )

                            [cursor:protected] => 4
                            [validPath:protected] => 1
                        )

                    [category_id] => 322
                    [displayedItemCount] => 72
                )

            [session:protected] => Array
                (
                    [offsetCount] => 72
                    [offsetStart] => 0
                    [category_path] => DD\Products\Category\Path Object
                        (
                            [path:protected] => Array
                                (
                                    [0] => 58
                                    [1] => 59
                                    [2] => 113
                                    [3] => 322
                                )

                            [cursor:protected] => 4
                            [validPath:protected] => 1
                        )

                    [category_id] => 322
                    [displayedItemCount] => 72
                )

        )

    [sqlFragments:protected] => Array
        (
            [DD\Products\Lists\Modifier\ActiveProductFilter] => DD\DataCollection\SQLFragment Object
                (
                    [requiredTables:protected] => Array
                        (
                            [0] => webshop_products
                            [1] => datasheet
                        )

                    [whereConditions:protected] => Array
                        (
                            [0] => webshop_products.active = ?
                            [1] => webshop_products.sale_start <= NOW()
                            [2] => webshop_products.sale_end >= NOW()
                            [3] => webshop_products.erv_end >= NOW()
                            [4] => datasheet.active = 1
                            [5] => IF(webshop_products.dbto != 0, IF(webshop_products.buyedcount < webshop_products.dbto, 1, 0), 1) = 1
                        )

                    [whereData:protected] => Array
                        (
                            [0] => 1
                            [1] => 
                            [2] => 
                            [3] => 
                            [4] => 
                            [5] => 
                        )

                    [limit:protected] => Array
                        (
                        )

                    [mergeOperator:protected] => AND
                    [orderBy:protected] => Array
                        (
                        )

                    [name:protected] => DD\Products\Lists\Modifier\ActiveProductFilter
                )

            [DD\Products\Lists\Modifier\CategoryFilter] => DD\DataCollection\SQLFragment Object
                (
                    [requiredTables:protected] => Array
                        (
                            [0] => webshop_product_categories
                        )

                    [whereConditions:protected] => Array
                        (
                            [0] => `webshop_product_categories`.`wc_id` IN (?, ?) 
                        )

                    [whereData:protected] => Array
                        (
                            [0] => 322
                            [1] => 322
                        )

                    [limit:protected] => Array
                        (
                        )

                    [mergeOperator:protected] => AND
                    [orderBy:protected] => Array
                        (
                        )

                    [name:protected] => DD\Products\Lists\Modifier\CategoryFilter
                )

            [DD\Products\Lists\Modifier\DailyDealFilter] => DD\DataCollection\SQLFragment Object
                (
                    [requiredTables:protected] => Array
                        (
                            [0] => wp_daily_deal
                        )

                    [whereConditions:protected] => Array
                        (
                            [0] => `wp_daily_deal`.`date` IS NULL
                        )

                    [whereData:protected] => Array
                        (
                        )

                    [limit:protected] => Array
                        (
                        )

                    [mergeOperator:protected] => AND
                    [orderBy:protected] => Array
                        (
                        )

                    [name:protected] => DD\Products\Lists\Modifier\DailyDealFilter
                )

        )

    [qb:protected] => Aura\SqlQuery\QueryFactory Object
        (
            [db:protected] => Mysql
            [common:protected] => 
            [quotes:protected] => Array
                (
                    [Common] => Array
                        (
                            [0] => "
                            [1] => "
                        )

                    [Mysql] => Array
                        (
                            [0] => `
                            [1] => `
                        )

                    [Pgsql] => Array
                        (
                            [0] => "
                            [1] => "
                        )

                    [Sqlite] => Array
                        (
                            [0] => "
                            [1] => "
                        )

                    [Sqlsrv] => Array
                        (
                            [0] => [
                            [1] => ]
                        )

                )

            [quote_name_prefix:protected] => `
            [quote_name_suffix:protected] => `
            [last_insert_id_names:protected] => Array
                (
                )

            [quoter:protected] => Aura\SqlQuery\Quoter Object
                (
                    [quote_name_prefix:protected] => `
                    [quote_name_suffix:protected] => `
                )

            [instance_count:protected] => 1
        )

    [builtQuery:protected] => Aura\SqlQuery\Mysql\Select Object
        (
            [union:protected] => Array
                (
                )

            [for_update:protected] => 
            [cols:protected] => Array
                (
                    [0] => webshop_products.id
                    [name] => webshop_products.name
                    [stitle] => webshop_products.smalltitle
                    [1] => webshop_products.price
                    [2] => webshop_products.sale
                    [3] => webshop_products.sale_price
                    [senddaate] => webshop_products.sale_end
                    [4] => webshop_products.city_id
                    [5] => webshop_products.vanajandek
                    [6] => webshop_products.exclusive
                    [7] => webshop_products.articleid
                    [8] => webshop_products.dbto
                    [9] => webshop_products.buyedcount
                    [10] => webshop_products.newsletter_text
                    [11] => webshop_products.seo_keyword
                    [12] => webshop_products.type
                    [category_id] => webshop_categories.id
                    [catname] => webshop_categories.name
                    [provider_name] => datasheet.title
                    [13] => datasheet.address
                    [14] => diamond_hunter.startDate
                    [15] => diamond_hunter.endDate
                    [16] => diamond_hunter.diamond
                    [17] => diamond_hunter.showOnFront
                    [daily_date] => wp_daily_deal.date
                    [daily_source_id] => wp_daily_deal.source
                    [18] => eternal_id_wp_rel.eternal_id
                )

            [from:protected] => Array
                (
                    [0] => Array
                        (
                            [0] => `webshop_products`
                        )

                )

            [from_key:protected] => 0
            [join:protected] => Array
                (
                    [0] => Array
                        (
                            [0] => INNER JOIN `webshop_product_categories` ON `webshop_products`.`id` = `webshop_product_categories`.`wp_id`
                            [1] => INNER JOIN `webshop_categories` ON `webshop_categories`.`id` = `webshop_product_categories`.`wc_id`
                            [2] => INNER JOIN `datasheet` ON `datasheet`.`id` = `webshop_products`.`datasheet_id`
                            [3] => INNER JOIN `eternal_id_wp_rel` ON `eternal_id_wp_rel`.`wp_id` = `webshop_products`.`id`
                            [4] => LEFT JOIN `diamond_hunter` ON `webshop_products`.`id` = `diamond_hunter`.`productId`
                            [5] => LEFT JOIN `wp_daily_deal` ON `wp_daily_deal`.`wp_id` = `webshop_products`.`id`
                        )

                )

            [group_by:protected] => Array
                (
                    [0] => `webshop_products`.`id`
                )

            [having:protected] => Array
                (
                )

            [page:protected] => 0
            [paging:protected] => 10
            [table_refs:protected] => Array
                (
                    [webshop_products] => FROM webshop_products
                    [webshop_product_categories] => INNER JOIN webshop_product_categories
                    [webshop_categories] => INNER JOIN webshop_categories
                    [datasheet] => INNER JOIN datasheet
                    [eternal_id_wp_rel] => INNER JOIN eternal_id_wp_rel
                    [diamond_hunter] => LEFT JOIN diamond_hunter
                    [wp_daily_deal] => LEFT JOIN wp_daily_deal
                )

            [bind_values:protected] => Array
                (
                    [_1_] => 1
                    [_2_] => 322
                    [_3_] => 322
                )

            [where:protected] => Array
                (
                    [0] =>  ( `webshop_products`.`active` = :_1_ AND `webshop_products`.`sale_start` <= NOW() AND `webshop_products`.`sale_end` >= NOW() AND `webshop_products`.`erv_end` >= NOW() AND `datasheet`.`active` = 1 AND IF(`webshop_products`.`dbto` != 0, IF(`webshop_products`.`buyedcount` < `webshop_products`.`dbto`, 1, 0), 1) = 1 ) 
                    [1] => AND  ( `webshop_product_categories`.`wc_id` IN (:_2_, :_3_)  ) 
                    [2] => AND  ( `wp_daily_deal`.`date` IS NULL ) 
                )

            [order_by:protected] => Array
                (
                )

            [limit:protected] => 72
            [offset:protected] => 0
            [flags:protected] => Array
                (
                )

            [quoter:protected] => Aura\SqlQuery\Quoter Object
                (
                    [quote_name_prefix:protected] => `
                    [quote_name_suffix:protected] => `
                )

            [seq_bind_prefix:protected] => 
        )

    [requestedTables:protected] => Array
        (
            [DD\Products\Lists\Modifier\ActiveProductFilter] => Array
                (
                    [0] => webshop_products
                    [1] => datasheet
                )

            [DD\Products\Lists\Modifier\CategoryFilter] => Array
                (
                    [0] => webshop_product_categories
                )

            [DD\Products\Lists\Modifier\DailyDealFilter] => Array
                (
                    [0] => wp_daily_deal
                )

        )

    [missingTables:protected] => Array
        (
        )

)
Diamond Deal Kft., Cégjegyzékszám: 13-09-149190 © 2011-2016 DiamondDeal.hu