Full URL: /dvds-movies/dvd-hd-dvd-blu-ray/action/i.html?cur=9&images=-1®ion=europe
GET parameters: Array
(
[cur] => 9
[images] => -1
[region] => europe
)
GPC parameters: Array
(
[cur] => 9
[images] => -1
[region] => europe
[cid] => 18883
[mode] => product
[sort] => 01
[page] => 1
[bidrange] =>
[radiuszip] =>
[list] => grid
)
fields: p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchases, p.c
timestamp: AND UNIX_TIMESTAMP(p.date_end) > UNIX_TIMESTAMP('2025-12-09 07:56:54')
projectstatus: AND p.status = 'open'
categories: AND (FIND_IN_SET(p.cid, '18883,'))
options: AND (p.hasimage = '0') AND (FIND_IN_SET(p.currencyid, '9'))
pricerange: AND (p.currentprice >= 0 OR p.buynow_price >= 0)
location: AND (FIND_IN_SET(p.countryid, '184,308,314,315,188,326,194,343,344,353,516,356,357,361,216,363,522,524,373,374,526,197,381,528,389,392,393,394,222,101,203,108,114,121,130,131,134,135,228,547,207,208,2
groupby: GROUP BY p.project_id
orderby: ORDER BY p.date_starts DESC
limit: LIMIT 0,12
from: FROM ilance_projects AS p
condition: 1=1
leftjoin: LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_prof
join_root_leftcat: LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.user_id = su.user_id)
LEFT JOIN ilance_payment_prof
join_child_leftcat: LEFT JOIN ilance_projects p ON (node.cid = p.cid)
LEFT JOIN ilance_users u ON (p.user_id = u.user_id)
LEFT JOIN ilance_events e ON (p.eventid = e.eventid)
LEFT JOIN ilance_subscription_user su ON (u.u
join_condition: AND u.status = 'active' AND su.active = 'yes' AND ((p.lotid > 0 AND p.eventid > 0 AND e.published = '1') OR (p.eventid <= 0)) AND p.visible = '1' AND p.password = '' AND p.isfrozensub = '0' AND pp.mod
final: SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
final_nolimit: SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
orderby_featured: ORDER BY p.date_end ASC
orderby_recent: ORDER BY p.date_added DESC
select: SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
select_nolimit: SELECT p.sku, p.gtc, p.password, p.storeid, p.bsin, p.featured, p.featured_searchresults, p.reserve, p.bold, p.highlite, p.buynow_qty, p.buynow, p.crypto_buynow_price, p.buynow_price, p.buynow_purchas
We didn't find results for DVDs & Movies : DVD, HD DVD & Blu-Ray : Action : Without pictures : EUR : Europe
You can also check out these finds:
