Getting Configurable Option Prices (SQL)

[gosuservers]

Hello,

 

I apologize if this has been asked before, but I couldn't find anyone with the same problem as me.

 

Anyway, I have all sorts of products with different configurable options (groups) and I am trying to display one set of configoption (Slots) appear on a PHP page with SQL. I am executing test SQL commands in phpmyadmin, but I am getting inconsistent prices next to the configoptions.

 

SQL:

SELECT p.name, t.monthly, c.code FROM tblproducts AS p INNER JOIN tblpricing AS t ON t.type='configoptions' AND t.relid = p.id INNER JOIN tblcurrencies AS c ON c.id = t.currency WHERE p.hidden != 'on' AND p.type ='other' ORDER BY `p`.`name` ASC

 

Output:

 

However the prices shown are not the prices I set up in the Configurable Options section and some prices don't show at all.

 

Can someone spot in my SQL statement where I am going wrong?

 

William