Re: [Phpmyadmin-devel] Rebuilding the sql from the scratch

Hi Marc, I mean for any case even it has multiple where clauses, the select part will not be changed. Rebuilding this first part messing up the query if there are sub queries. In following query unchanged first part is in bold. *SELECT `id`, `name` FROM `customers`* WHERE id NOT IN ( SELECT id FROM companies WHERE name LIKE '%u%') Apart from that, SQL with several where clauses, can be represented as a one SQL query (without any sub queries and with only one where clause). Currently that's reached by using the primary key values of the resulted table rows which are going to export. But when building new where clause, other than only combining those primary key values with 'OR' clause, at the end another clause is appended which is from analyzed sql [0]. That where clause is the last where clause of the original SQL query. I don't see any use of this since we already can identify the rows by primary key. Your thoughts on this will be very helpful to go forward correctly. [0] : https://github.com/phpmyadmin/phpmyadmin/blob/master/tbl_export.php#L61 Regards ! -- Chanaka Dharmarathna *Virtusa (Pvt) Ltd. | **Sri Lanka*