SQLSTATE[42S02]: Base table or view not found: 1146 Table 'sspatial_db.ads_select' doesn't exist
SELECT ads.ads_id, ads.type, ads.name, ads.photo, ads.photo_footer, CONCAT('/resource/ads/',ads.photo_intro_desktop) AS pic, CONCAT('/resource/ads/',ads.photo_intro_mobile) AS pic_mobile, ads.url, ads.seo, ads.code, aset.position_id, aset.cat_id
		FROM ads_set AS aset
		LEFT JOIN ads ON (aset.ads_id = ads.ads_id)
		WHERE aset.ads_id > (SELECT ads_id FROM ads_select WHERE position_id = '7' AND cat_id = '0')
		  AND aset.position_id = '7'
		  AND aset.cat_id = '0'
		  AND ads.begin_date <= NOW()
		  AND ads.end_date >= NOW()
		ORDER BY aset.ads_id ASC
		LIMIT 1

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ads.photo_footer' in 'field list'
SELECT ads.ads_id, ads.type, ads.name, ads.photo, ads.photo_footer, CONCAT('/resource/ads/',ads.photo_intro_desktop) AS pic, CONCAT('/resource/ads/',ads.photo_intro_mobile) AS pic_mobile, ads.url, ads.seo, ads.code, aset.position_id, aset.cat_id
		FROM ads_set AS aset
		LEFT JOIN ads ON (aset.ads_id = ads.ads_id)
		WHERE aset.position_id = '7'
		AND aset.cat_id = '0'
		AND ads.begin_date <= NOW()
		AND ads.end_date >= NOW()
		ORDER BY aset.ads_id ASC
		LIMIT 1




    

    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    
    sspatial.com
    
    
    
    
    
    
    

        
        

        
        






  • BY
  • 5 views

  • BY
  • 5 views

  • BY
  • 5 views

X INTERESTING
    arrow ENTER
    X
    X