DB Error: no such field
|   
|   SELECT COUNT(DISTINCT tbl_banner.tbl_banner_id) as totalrecords
|   FROM
|      tbl_banner
|      LEFT JOIN tbl_profile
|         ON (tbl_banner.tbl_banner_x_profile_id = tbl_profile.tbl_profile_id )LEFT JOIN tbl_rating
|                                    ON (tbl_banner.tbl_banner_id = tbl_rating.tbl_rating_x_component_item_id AND tbl_rating.tbl_rating_x_component_id = "1041")
|   WHERE TRUE
|       AND 1 AND tbl_banner_show = "1"
|   GROUP BY
|      tbl_banner_id
|   ORDER BY
|      rating desc,
|      tbl_banner_name asc;
|   
|    [nativecode=1054 ** Unknown column 'rating' in 'order clause'] // 1. # 531 - /usr/local/lib/php/PEAR.php
// 2. # 498 - /home/dolfinariu/domains/spetter.nl/public_html/libs/dblayer/db/common.php
// 3. # 813 - /home/dolfinariu/domains/spetter.nl/public_html/libs/dblayer/db/mysql.php
// 4. # 231 - /home/dolfinariu/domains/spetter.nl/public_html/libs/dblayer/db/mysql.php
// 5. #1145 - /home/dolfinariu/domains/spetter.nl/public_html/libs/dblayer/db/common.php
// 6. # 669 - /home/dolfinariu/domains/spetter.nl/public_html/classes/DataSource.class.php
// 7. #1840 - /home/dolfinariu/domains/spetter.nl/public_html/classes/DataSource.class.php
// 8. # 44 - /home/dolfinariu/domains/spetter.nl/public_html/classes/TList/Driver/TList.Driver.Html.class.php
// 9. # -
// 10. # 156 - /home/dolfinariu/domains/spetter.nl/public_html/classes/TList.class.php
// 11. # 250 - /home/dolfinariu/domains/spetter.nl/public_html/classes/TList.class.php
// 12. # 38 - /home/dolfinariu/domains/spetter.nl/public_html/components/banner/blocks/dsp_banner_list.php
// 13. # 15 - /home/dolfinariu/domains/spetter.nl/public_html/components/banner/index.php
// 14. # 89 - /home/dolfinariu/domains/spetter.nl/public_html/index.php

maak spandoek