newbie trying to understand db query in also_purchased_produ

[Paulz]

Hi, Id v.much appreciate if you could explain the following:

what is the value of " opa, " in the following script?

 

if ($HTTP_GET_VARS['products_id']) {

$orders_query = tep_db_query("select p.products_id, p.products_image from " . TABLE_ORDERS_PRODUCTS . " opa, " . TABLE_ORDERS_PRODUCTS . " opb, " . TABLE_ORDERS . " o, " . TABLE_PRODUCTS . " p where opa.products_id = '" .

 

I suspect it may be a variable that will hold a value from TABLE_ORDERS_PRODUCTS but I cant get my head round this?

please help :?: