GF::dump() at line 2153 in ProductEx
array
(
0 => '_FP:45a7e305d084cfc197fff8f8954e6168'
1 => ' AND ( g.locationCountryId IN (2) OR 0 OR ( IF(pgi_p.productId IS NOT NULL, FIND_IN_SET(\'2\', pgi_p.countryIds) , pi.showInAllLocationsGlobally = 1) OR pi.showInAllLocationsNationally = 1 AND
IF(pgi_p.productId IS NOT NULL,
FIND_IN_SET(\'2\', pgi_p.countryIds) ,
g.locationCountryId IN (
SELECT l.countryId
FROM iocontentdb.locales l
JOIN iocontentdb.geographics geo ON geo.localeId = l.localeId
WHERE geo.geographicId IN (18557)
)
OR
cb.localeId IN (
SELECT l2.localeId
FROM iocontentdb.locales l
JOIN iocontentdb.geographics geo ON geo.localeId = l.localeId
JOIN iocontentdb.locales l2 ON l2.countryId = l.countryId
WHERE geo.geographicId IN (18557)
)
) ) ) AND ( ( pt.sellable = 1
AND pt.physical = 0
AND pt.service = 0
AND pt.sweepstakesEntry = 0
AND pt.hidePriceOnTile = 0
AND pt.isBenefit = 0 ) OR (au.productId IS NOT NULL AND NOW() >= au.startTime AND NOW() <= au.endTime) OR (sw.sweepstakeId IS NOT NULL AND NOW() >= sw.startTime AND NOW() <= sw.endTime) OR ( pt.experience = 1 AND pt.physical = 1 ) )'
)