Error Number: 1066
Not unique table/alias: 'sp_categories_entries'
SELECT DISTINCT `sp_entries`.*, `field_id_124`, `field_id_125`, `field_id_126`, `field_id_127`, `field_id_128`, `field_id_129`, `field_id_130`, `field_id_131`, `field_id_132`, `sp_content_types`.`dynamic_route`, `sp_content_types`.`layout`, `sp_content_types`.`short_name` FROM (`sp_entries`) JOIN `sp_entries_data` ON `sp_entries`.`id` = `sp_entries_data`.`entry_id` JOIN `sp_content_types` ON `sp_entries`.`content_type_id` = `sp_content_types`.`id` JOIN `sp_categories_entries` ON `sp_entries`.`id` = `sp_categories_entries`.`entry_id` JOIN `sp_categories_entries` ON `sp_entries`.`id` = `sp_categories_entries`.`entry_id` JOIN `sp_categories` ON `sp_categories_entries`.`category_id` = `sp_categories`.`id` WHERE `status` = 'published' AND `short_name` IN ('shto_dokumente_publikime_kpk') AND `category_id` IN ('84') AND `sp_categories`.`url_title` = 'subcategory' AND `field_id_127` IS NOT NULL ORDER BY `created_date` DESC LIMIT 6
Filename: /home/prokuroriaks/public_html/application/modules/content/libraries/Entries_library.php
Line Number: 150