Attribute Problems after 158 Move

[simon1066]

Using the site's phpMyAdmin, what results come back from the following query?

SELECT pa.*
                                     FROM (proucts_attributes pa
                                     LEFT JOIN products_options po ON pa.options_id = po.products_options_id
                                       AND po.language_id = 1)
                                     WHERE pa.products_id = 101
                                     ORDER BY LPAD(po.products_options_sort_order,11,'0'),
                                              LPAD(pa.options_id,11,'0'),
                                              LPAD(pa.products_options_sort_order,11,'0')

P.S. I'm assuming that the site's database doesn't use table-prefixes.

Little typo,

SELECT pa.*
                                     FROM (products_attributes pa
                                     LEFT JOIN products_options po ON pa.options_id = po.products_options_id
                                       AND po.language_id = 1)
                                     WHERE pa.products_id = 101
                                     ORDER BY LPAD(po.products_options_sort_order,11,'0'),
                                              LPAD(pa.options_id,11,'0'),
                                              LPAD(pa.products_options_sort_order,11,'0')

Edit: just noticed it was for @dbltoe, who would have realised this.