You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND data_keys.website_id = '50' AND data_keys.key = 'orderproducts'' at line 1:
SELECT data.*, data.order as `order`, data211.id AS `orders`, data211.id AS `orders_id`, data211.data_created AS `orders_data_created`, data211.data_modified AS `orders_data_modified`, data211.data_created_by AS `orders_data_created_by`, data211.data_modified_by AS `orders_data_modified_by`, data211.data_key_id AS `orders_data_key_id`, data211.data_display AS `orders_data_display`, data211.short_url AS `orders_short_url`, data211.order AS `orders_order`, text311.text_title AS `orders_session`, numbers312.number AS `orders_status`, text313.text_title AS `orders_billingemail`, text314.text_title AS `orders_billingfirstname`, text315.text_title AS `orders_billinglastname`, text316.text_title AS `orders_billingaddressline1`, text317.text_title AS `orders_billingaddressline2`, text318.text_title AS `orders_billingcity`, text319.text_title AS `orders_billingstate`, text3110.text_title AS `orders_billingzip`, text3111.text_title AS `orders_billingdayphone`, text3112.text_title AS `orders_billingevephone`, text3113.text_title AS `orders_shippingfirstname`, text3114.text_title AS `orders_shippinglastname`, text3115.text_title AS `orders_shippingemail`, text3116.text_title AS `orders_shippingaddressline1`, text3117.text_title AS `orders_shippingaddressline2`, text3118.text_title AS `orders_shippingcity`, text3119.text_title AS `orders_shippingstate`, text3120.text_title AS `orders_shippingzip`, text3121.text_title AS `orders_shippingdayphone`, text3122.text_title AS `orders_shippingevephone`, text3123.text_title AS `orders_token`, text3124.text_title AS `orders_billingcountry`, text3125.text_title AS `orders_shippingcountry`, numbers3126.ip_address AS `orders_ipaddress`, text3127.text_title AS `orders_shippingstatus`, text3128.text_title AS `orders_shipper`, text3129.text_title AS `orders_trackingnumber`, text3130.text_title AS `orders_shippingurl`, data212.id AS `products`, data212.id AS `products_id`, data212.data_created AS `products_data_created`, data212.data_modified AS `products_data_modified`, data212.data_created_by AS `products_data_created_by`, data212.data_modified_by AS `products_data_modified_by`, data212.data_key_id AS `products_data_key_id`, data212.data_display AS `products_data_display`, data212.short_url AS `products_short_url`, data212.order AS `products_order`, text321.text_title AS `products_title`, text322.text_description AS `products_description`, numbers323.price AS `products_price`, numbers324.price AS `products_shippingprice`, numbers325.number AS `products_inventory`, numbers326.number AS `products_buycount`, numbers327.binary AS `products_featured`, numbers328.binary AS `products_display`, text329.text_title AS `products_type`, numbers3210.binary AS `products_showsizes`, numbers3211.binary AS `products_xsmall`, numbers3212.binary AS `products_small`, numbers3213.binary AS `products_medium`, numbers3214.binary AS `products_large`, numbers3215.binary AS `products_xlarge`, numbers3216.binary AS `products_xxlarge`, numbers213.number AS `quantity`, text214.text_description AS `productinfo`, numbers215.number AS `downloadcount`, text216.text_title AS `displaytitle` FROM data LEFT JOIN data_keys ON data_keys.data_key_id=data.data_key_id LEFT JOIN data_binds AS `db111` ON db111.data_id=data.id LEFT JOIN data AS `data211` ON data211.id=db111.node1_id LEFT JOIN data_binds AS `db211` ON db211.data_id=data211.id LEFT JOIN text AS `text311` ON text311.text_id=db211.node1_id LEFT JOIN numbers AS `numbers312` ON numbers312.number_id=db211.node2_id LEFT JOIN text AS `text313` ON text313.text_id=db211.node3_id LEFT JOIN text AS `text314` ON text314.text_id=db211.node4_id LEFT JOIN text AS `text315` ON text315.text_id=db211.node5_id LEFT JOIN text AS `text316` ON text316.text_id=db211.node6_id LEFT JOIN text AS `text317` ON text317.text_id=db211.node7_id LEFT JOIN text AS `text318` ON text318.text_id=db211.node8_id LEFT JOIN text AS `text319` ON text319.text_id=db211.node9_id LEFT JOIN text AS `text3110` ON text3110.text_id=db211.node10_id LEFT JOIN text AS `text3111` ON text3111.text_id=db211.node11_id LEFT JOIN text AS `text3112` ON text3112.text_id=db211.node12_id LEFT JOIN text AS `text3113` ON text3113.text_id=db211.node13_id LEFT JOIN text AS `text3114` ON text3114.text_id=db211.node14_id LEFT JOIN text AS `text3115` ON text3115.text_id=db211.node15_id LEFT JOIN text AS `text3116` ON text3116.text_id=db211.node16_id LEFT JOIN text AS `text3117` ON text3117.text_id=db211.node17_id LEFT JOIN text AS `text3118` ON text3118.text_id=db211.node18_id LEFT JOIN text AS `text3119` ON text3119.text_id=db211.node19_id LEFT JOIN text AS `text3120` ON text3120.text_id=db211.node20_id LEFT JOIN text AS `text3121` ON text3121.text_id=db211.node21_id LEFT JOIN text AS `text3122` ON text3122.text_id=db211.node22_id LEFT JOIN text AS `text3123` ON text3123.text_id=db211.node23_id LEFT JOIN text AS `text3124` ON text3124.text_id=db211.node24_id LEFT JOIN text AS `text3125` ON text3125.text_id=db211.node25_id LEFT JOIN numbers AS `numbers3126` ON numbers3126.number_id=db211.node26_id LEFT JOIN text AS `text3127` ON text3127.text_id=db211.node27_id LEFT JOIN text AS `text3128` ON text3128.text_id=db211.node28_id LEFT JOIN text AS `text3129` ON text3129.text_id=db211.node29_id LEFT JOIN text AS `text3130` ON text3130.text_id=db211.node30_id LEFT JOIN data AS `data212` ON data212.id=db111.node2_id LEFT JOIN data_binds AS `db212` ON db212.data_id=data212.id LEFT JOIN text AS `text321` ON text321.text_id=db212.node1_id LEFT JOIN text AS `text322` ON text322.text_id=db212.node2_id LEFT JOIN numbers AS `numbers323` ON numbers323.number_id=db212.node3_id LEFT JOIN numbers AS `numbers324` ON numbers324.number_id=db212.node4_id LEFT JOIN numbers AS `numbers325` ON numbers325.number_id=db212.node5_id LEFT JOIN numbers AS `numbers326` ON numbers326.number_id=db212.node6_id LEFT JOIN numbers AS `numbers327` ON numbers327.number_id=db212.node7_id LEFT JOIN numbers AS `numbers328` ON numbers328.number_id=db212.node8_id LEFT JOIN text AS `text329` ON text329.text_id=db212.node9_id LEFT JOIN numbers AS `numbers3210` ON numbers3210.number_id=db212.node10_id LEFT JOIN numbers AS `numbers3211` ON numbers3211.number_id=db212.node11_id LEFT JOIN numbers AS `numbers3212` ON numbers3212.number_id=db212.node12_id LEFT JOIN numbers AS `numbers3213` ON numbers3213.number_id=db212.node13_id LEFT JOIN numbers AS `numbers3214` ON numbers3214.number_id=db212.node14_id LEFT JOIN numbers AS `numbers3215` ON numbers3215.number_id=db212.node15_id LEFT JOIN numbers AS `numbers3216` ON numbers3216.number_id=db212.node16_id LEFT JOIN numbers AS `numbers213` ON numbers213.number_id=db111.node3_id LEFT JOIN text AS `text214` ON text214.text_id=db111.node4_id LEFT JOIN numbers AS `numbers215` ON numbers215.number_id=db111.node5_id LEFT JOIN text AS `text216` ON text216.text_id=db111.node6_id WHERE text311.text_title = AND data_keys.website_id = '50' AND data_keys.key = 'orderproducts' ;