| Fatal Error: |
| SELECT external_url, packages.id, package_link, package_name, short_desc, price_from, package_image_main
FROM packages LEFT JOIN packages_dates ON packages.id = packages_dates.id_package
LEFT JOIN packages_groups ON packages_groups.package_id = packages.id
WHERE package_active AND packages.enabled_ind
AND packages.publish_date <= CURRENT_DATE()
AND packages.unpublish_date >= CURRENT_DATE()
AND(
(
packages_dates.dates_value >= DATE_ADD( CURRENT_DATE( ) , INTERVAL( packages.cutoff_days + 2 ) DAY )
AND packages_dates.enabled_ind
)
OR packages.id NOT IN(
SELECT DISTINCT id_package FROM packages_dates WHERE packages_dates.enabled_ind
)
)
AND country_id in (155, 117, 116, 118) AND group_id ='107' GROUP BY packages.id ORDER BY packages_groups.sort_order desc, packages.id desc DBError #1052: Column 'group_id' in where clause is ambiguous in Engine |